Extract dates

[John]

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

 

[Mike H]

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]

Thank you Mike
It's working well.
Regards
John

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