Date issues

[Hank01061567]

Hi,

Does anyone know the formula that would return the month end dates beweeen a
start date and end date (cell references).

I.e. for...
Start Date 31/12/2009
End date 31/03/2010

i want it to return the following

31/12/2009
31/01/2010
28/02/2010
31/03/2010

Thanks in advance for any ideas or suggestions

 

[Ron Rosenfeld]

Hi,

Does anyone know the formula that would return the month end dates beweeen a
start date and end date (cell references).

I.e. for...
Start Date 31/12/2009
End date 31/03/2010

i want it to return the following

31/12/2009
31/01/2010
28/02/2010
31/03/2010

Thanks in advance for any ideas or suggestions

Here's one method that might work:

In some cell, enter the formula:

=IF(EOMONTH(Start_Date,ROWS($1:1)-1)>End_Date,"",
EOMONTH(Start_Date,ROWS($1:1)-1))

Start_Date and End_Date refer to cells where those dates are stored.

Then fill down at least as far as required. Entries past the End Date will
show blank.

If the formula results in a #NAME error, and you have a version of Excel prior
to 2007, see HELP for the EOMONTH function for instructions as to how to
resolve it.
--ron