end of month

[Guest]

How do I get end of month in a field given a date?


Eg. 10/5/2004 should give me 10/31/2004

Thanks

 

[HCJ]

Try, for a date in A1: =DATE(YEAR(A1),MONTH(A1)+1,0)

 

[Myrna Larson]

If you have the Analysis Tool Pak installed, use its EOMONTH formula with 0 as
the 2nd argument.

If not, assuming 10/5/2004 is in A1 =DATE(YEAR(A1),MONTH(A1)+1,0)

i.e. the 0th day of next month is the last day of this month.

 

[Guest]

Thanks much...that worked like a charm!!!

-----Original Message-----
Try, for a date in A1: =DATE(YEAR(A1),MONTH(A1)+1,0)

.