I want last days of the month in cells A1-A12
 

How do I tell Excel 2007 to calculate the last day of the month

.....Lisa

I want last days of the month in cells A1-A12
 

EOMONTH function.
--
Gnothi se auton.


"hamiltoncruiser" wrote:

How do I tell Excel 2007 to calculate the last day of the month

.....Lisa

I want last days of the month in cells A1-A12
 

On Thu, 22 Nov 2007 07:33:48 -0800 (PST), hamiltoncruiser
wrote:

How do I tell Excel 2007 to calculate the last day of the month

....Lisa

=DATE(year(dt),month(dt)+1,0)

or

=EOMONTH(dt,0)

dt can be an actual date, or a reference to a cell containing a date.
--ron

I want last days of the month in cells A1-A12
 

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"hamiltoncruiser" escreveu:

How do I tell Excel 2007 to calculate the last day of the month

.....Lisa