John,

Put this in the cell where you want the list of dates to start and drag dwon
intil it starts returning blank cells.

=IF($A$3+ROW(A1)-1<=$B$3,$A$3+ROW(A1)-1,"")

Mike

"John" wrote:

Hi Everyone

I have a form with dates entered as:
Start date ( Cell A3) 01/05/08 End date (Cell B3) 01/08/08
Is it possible with a formula or a macro to list each date in separate cell.
This should give me 4 days including start date.
Thanking you in advance
Regards
John