Thank you Mike
It's working well.
Regards
John
"Mike H" wrote in message
...
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