Excel Dates
 

If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get
another cell to automatically give me the last date of that month (i.e. 31
March 2007 in cell A2)?
--
Erwin

Excel Dates
 

Tue, 5 Jun 2007 21:51:00 -0700 from Erwin
:
If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get
another cell to automatically give me the last date of that month (i.e. 31
March 2007 in cell A2)?

=EOMONTH(A1,0)

Pretty cool, huh?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Excel Dates
 

One way (without needing the Analysis Toolpak Add-in's EOMONTH):

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

Format as a Date.

In article ,
Erwin wrote:

If I enter a date in one cell (i.e. 7 March 2007 in cell A1), how do I get
another cell to automatically give me the last date of that month (i.e. 31
March 2007 in cell A2)?