Date issues

H

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top