| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract dates
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract dates
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract dates
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| extract and sort dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
![John[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
