Cannot bring out the month & year from a date

Posted to microsoft.public.excel.worksheet.functions

San[_4_]

external usenet poster

Posts: 26

Cannot bring out the month & year from a date

Hi

I would like to bring out the month from a given date in the format 'mmm-yy'. The original date is in dd/mm/yyyy format.

But when I am using the Month function with format "mmm-yy", it is giving an erratic result.

Say for example,

A2 B2

15/04/2015 =MONTH(A2) Result = Jan-00

Why is this happening?

regards

San

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract Month and year from Cell containing date, month, year & time	Montenegro Mick	Excel Worksheet Functions	2	May 2nd 12 03:17 AM
Date(Year,Month,Day) not returnign correct date	jlclyde	Excel Discussion (Misc queries)	8	October 16th 09 02:42 PM
count month when date is in day/month/year format	ccKennedy	Excel Worksheet Functions	6	April 30th 09 03:32 AM
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)???	misscrf	Excel Discussion (Misc queries)	1	December 14th 07 02:59 PM
Sort month/date/year data using month and date only	SMW820	Excel Discussion (Misc queries)	6	June 22nd 06 05:14 PM

All times are GMT +1. The time now is 07:11 AM.

Menu

About Us