| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filling in missing dates
I have a long series of daily data ( 10 years, one line per day) that is
missing a few hundred dates here and there. Is there any way to get Excel to insert blank lines for the missing days so that I have a single line for every day of every year? Thank you! HB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Threaded Mode
