Thread
:
Monthly dates on Reports
View Single Post
#
5
Posted to microsoft.public.excel.misc
Wanna Learn
external usenet poster
Posts: 318
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
Reply With Quote
Wanna Learn
View Public Profile
Find all posts by Wanna Learn