Extract dates

J

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
 
M

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
 
J

John

Thank you Mike
It's working well.
Regards
John
Mike H said:
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
Click to expand...
 
Top