Please suggest an excel formula that how to convert date format 'DD/MM/YYYY" into "MM/YYYY'?
For an example:-04/01/2014 should be Jan-2014 or Jan-14
Please suggest an excel formula that how to convert date format 'DD/MM/YYYY" into "MM/YYYY'?
For an example:-04/01/2014 should be Jan-2014 or Jan-14
Regards
Pradeep Kumar Gupta
Gurgaon ( INDIA )
change cellformat to mmm-yyyy or mmm-yy
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
You are able to make your own - so named "custom" formats.
Right click follow Fomat cells... then Category: custom write to box Type: mm.yyyy and confirm ENTER.
You can use also Type: mmmm "-" yyyy
Or use something like this: =TEXT(A1;"mmmm.yyyy") suppose in cell A1 = 14.1.2014 => result is january.2014
Or =TEXT(A1;"mmmm - yyyy")
I hope it helped
Thanks for the nice formula.Glad.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks