View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
picklet222
 
Posts: n/a
Default 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