Hi Rose
Instead of letting A1 increment as you copy down, hold A1 constant with
the absolute reference $A$1 and let the increment increase by using
ROW(1:1). In A2
=$A$1+ROW(1:1)
As you copy down, row will increment by 1 each time and you will get the
correct end of month for the whole tear.
--
Regards
Roger Govier
"ROSE2102" wrote
in message ...
I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The
next date is 02/28/2006 however all subsequent days are now the 28th
of
each month, not the actual last day of the month. Can you please
advise
how I can correct this formula?
--
ROSE2102
------------------------------------------------------------------------
ROSE2102's Profile:
http://www.excelforum.com/member.php...fo&userid=9202
View this thread:
http://www.excelforum.com/showthread...hreadid=503441