=Text(YourDate,"mmm-yy")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Imran khan
Sent: Jan/Tue/2012 12:25
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel formula for Dates
I have date 17-Jan-12. I want formula to get only Jan-1
Dear Imran,
Please try
=text(17-Jan-12,"mmm-yy")
On Tue, Jan 17, 2012 at 12:25 PM, Imran khan wrote:
> I have date 17-Jan-12. I want formula to get only Jan-12. Please help me.
>
> Regards,
> Imran
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thr
*=TEXT(A1,"MMM-YY")
*
On Tue, Jan 17, 2012 at 10:55 AM, Imran khan wrote:
> I have date 17-Jan-12. I want formula to get only Jan-12. Please help me.
>
> Regards,
> Imran
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread title
