View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wanna Learn Wanna Learn is offline
external usenet poster
 
Posts: 318
Default Monthly dates on Reports

Thanks Don
This works better for me

"Don Guillett" wrote:

=J1+IF(WEEKDAY(J1+1)=7,3,1)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Wanna Learn" wrote in message
...
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