I need to have identical spreadsheets for each month and cells that have service dates that are always the same day of each month.
I would like to have only the month in the cells change according to the "absolute" cell that I have assigned to each month’s spreadsheet
(i.e. January spreadsheet has JANUARY in cell K1 and A3 1/1/2015, A4 1/5/2015, A5 1/8/2015, A6 1/12/2015 ..... I would like to be able to create a copy of the whole JAN spreadsheet, rename it FEB, change K1 to FEBRUARY and have A3, A4, A5, A6,.... update automatically to say 2/1/2015, 2/5/2015, 2/8/2015,2/12/2015,......)
Bookmarks