auto input on list of selection dates

Hi,

How to make an auto input on list of selection dates by giving only the starting date and ending date.

Given:
List of selection dates only:
15-Aug-08
30-Aug-08
15-Sep-08
30-Sep-08
15-Oct-08
30-Oct-08
15-Nov-08
30-Nov-08
15-Dec-08
30-Dec-08
and so on...

Inputs:
Starting date: 30-Aug-08
Ending date:30-Oct-08

and output should be like this:

30-Aug-08
15-Sep-08
30-Sep-08
15-Oct-08
30-Oct-08

I hope there is a simple solution for this..
thanks,
Oliver

Here is one solution
HTH
Ola

You could enter a date in the first cell (say A1), and then in A2 and copy down,

=IF(DAY(E1) = 30, EOMONTH(E1, 0), E1) + 15

Requires the Analysis Toolpak add-in.

thanks.. both works fine,

Hi shg,

the solution works great, but when it comes to the month of February your formula will not work because february is less than 30 days. Is there a remedy for this?

thanks a lot
Oliver

it works perfectly... thanks again

Hi Shg,

Some little problem with the formula you've given,

Please Login or Register  to view this content.

I'm using Office2007, but the document i've done, i have save it in 1997-2003 version, so if i'm using 2007version your formula works perfectly, but when it is opened with 2003version it is giving problem.. I tried check what is the cause but still cannot find the reason, just new in excel.

kindly need your guidance on this one..
thanks,
Oliver

Hi Shg,

No need to reply, too much condition i have included that is the problem, now i have fixed it.

Thanks again.