Date Function

[cmgrubb]

I'm looking to automatically figure out the last day of the current month from a cell that has a date it in it. Example: A1 = 02/14/08 and I want B1 to automatically calculater 02/29/08. (leap year). Thanks

[NBVC]

Try:

=EOMONTH(A1,0)

this is an Analysis Toolpak function... Tools|Addins >> Analysis Toolpak

[daddylonglegs]

Without Analysis ToolPak the standard approach is

=DATE(YEAR(A1),MONTH(A1)+1,0)

or if you want something a little less transparent but a little more exotic try

=A1-DAY(A1)+32-DAY(A1-DAY(A1)+32)