I have spreadsheets which have dates listed in Column A with other data in subsequent columns. There may be multiples (even hundreds) of one date listed (see example below).
5-May-08
6-May-08
7-May-08
7-May-08
7-May-08
8-May-08
There are also missing dates (e.g. 1-May-08 to 4-May-08). Ultimately, I need every day of a month represented in the list. So, I need to have rows inserted where a missing date should be, and then I need those dates added in the list. The dates will be sequential. No dates/data should be removed.
Along with this, I need a '0' added in four cells on the newly added row (typically L-O).
Thanks in advance!