Month End

[NavinReddy]

Dear All,

=date(date(MonthEnd(today()),'dd/mm/yyyy'),'dd/mm/yyyy')

I am using this to Disply monthend date but im  getting 28/59/2014 like this format

could some one help me disply this monthend date

Thanks In Advance

Niranjan

[johnca]

=date#(MonthEnd(Today()),'dd/mm/yyyy') will return 2/28/2014.

Note the # sign.

[NavinReddy · Accepted solution]

=Date(MonthEnd(Date(Date(Today(),'YYMM'),'MM-YYYY')),'DD/MM/YYYY')

this will return my format

[Sokkorn]

Hi Niranjan,

'dd/mm/yyyy' -> mm here will consider as minute. For date format it should be capital letter 'MM'.

Let try this =date(date(MonthEnd(today()),'dd/MM/yyyy'),'dd/MM/yyyy')

Or simply =date(MonthEnd(today()),'dd/MM/yyyy')

Regards,

Sokkorn

[johnca]

A more simple answer would be:

=date(MonthEnd(Today()),'DD/MM/YYYY')

This also returns 28/02/2014.

(I misread your format the first time)