Excel Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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)?
Click to expand...

=EOMONTH(A1,0)

Pretty cool, huh?
 
One way (without needing the Analysis Toolpak Add-in's EOMONTH):

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

Format as a Date.
 
Back
Top