software

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: www.excelforum.com/member.php...foamp;userid=9202
View this thread: www.excelforum.com/showthread...hreadid=503441Hi 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 Govierquot;ROSE2102quot; gt; wrote
in message ...
gt;
gt; I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The
gt; next date is 02/28/2006 however all subsequent days are now the 28th
gt; of
gt; each month, not the actual last day of the month. Can you please
gt; advise
gt; how I can correct this formula?
gt;
gt;
gt; --
gt; ROSE2102
gt; ------------------------------------------------------------------------
gt; ROSE2102's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9202
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=503441
gt;
If you're looking for last days of months, then how about using the EOMONTH
function instead?

=EOMONTH(A1,1)
That would return 2/28/06

=EOMONTH(A1,2)
Returns 3/31/06

HTH,
Elkar

quot;ROSE2102quot; wrote:

gt;
gt; I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The
gt; next date is 02/28/2006 however all subsequent days are now the 28th of
gt; each month, not the actual last day of the month. Can you please advise
gt; how I can correct this formula?
gt;
gt;
gt; --
gt; ROSE2102
gt; ------------------------------------------------------------------------
gt; ROSE2102's Profile: www.excelforum.com/member.php...foamp;userid=9202
gt; View this thread: www.excelforum.com/showthread...hreadid=503441
gt;
gt;