convert Month

[sambit]

Hi,
when i put
=Month(Now()) it is showing 12 i.e, OK
but when we convert the format it shows as "January" Why ?

also
=TEXT(MONTH(NOW()),"MMMM")
the above formula showing as "January" but it should be "December".

why?

 

[Somendra Misra]

Hi Sambit,

The result of formula is 12 which when converted to date format, will result in 12-Jan-1900.

As date in Excel are serial numbers starting from 1st day of 1900 as 1.

Instead use: =TEXT(NOW(),"MMMM")

Regards,

 

[sambit]

Somendra Sir,
Thank you very much.