Dates on a worksheet
Hi
=DATE(YEAR(A1),MONTH(A1)+2,0)
=DATE(YEAR(A1),MONTH(A1)+4,0)
etc.
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"climber322" wrote in message
...
I want to be able to input a date and have the spreadsheet automatically
list
the proceeding months with the last day of the month. In other words, if
in
cell A1 I enter 01/31/2008, I want to automatically see 02/28/2008 in A2,
then 03/31/2008 in A3, etc. If I key in 07/31/2008 in A1, I'd like to see
08/31/2008 in A2, 09/30,2008 in A3, etc.
|