Assuming Day1 date is in A1, use
=A1+3-(WEEKDAY(A1+3)=1)*2-(WEEKDAY(A1+3)=7)*1
--
HTH
-------
Bob Phillips
"hanauer" wrote in message
...
I want to set up a list of milestones in Excel (i.e., project starts on
Day
1, writers identified on day 3, drafts due on day 10, etc.) where I can
type
in the start date and have Excel fill in the dates for each milestone
automatically. If Day 3 falls on a weekend, how can I make Excel change
that
result to the weekday previous to it?
|