Find Month Using Dates

[nandhamnk]

Dear All,


I need help on identifying month based on dates.

Example,


12/7/2012 - July-12 (Answer)

If Date is blank,formula should also blank.

 

[Luke M]

If you're wanting to know month and year, I think this will work for you.

=IF(ISNUMBER(A2),TEXT(A2,"mmm-yy"),"")

 

[Debraj]

Hi nandhamnk,


Use

=IF(ISBLANK(A1),"",TEXT(A1,"MMMM-YY")) or you can use =IF(ISBLANK(A1),"",MONTH(A1))

it will gives you only 7 in case of JULY..


Regards,

Deb

 

[sdsurzh]

Hi,


Can you please try the below formula.


=IF(A1>0,TEXT(A1,"mmmm"&" "&"yyyy")," ")


Thanks,

Suresh Kumar S

 

[nandhamnk]

Thanks to all.Above formula works.

 

[Luke M]

Glad we could help, thanks for the feedback!

 

[nazmul_muneer]

Dear nandhamnk,

You can try the formula

=IF(NOT(ISBLANK(A1)),TEXT(A1,"mmmm-yy"),"")


--Muneer

 

[Haseeb A]

Also, using ";;;" in TEXT


=TEXT(A2,"mmm-yy;;;")