Hello I have a monthly report with worksheets for each working day of the
month, Monday thru Friday. I use the same report every month I just change
the month. the report tilte is the name as the day of the month e.g.
September 4 2007 the next sheet is September5 2007 etc.(I'm always one day
behind, on Sep 5 I will be doing report for Sep 4 ) On the first worksheet
of the month I type in the date. the second sheet of the month I entered the
formula =Sep407!J1+1 . The problem is that every monday I have to adjust the
formula, to compensate for Sat and Sun. Is there a formulat that if I enter
the date on the first worksheet it will automatically update the entire
workbook correctly. thanks