View Single Post
  #1   Report Post  
hanauer
 
Posts: n/a
Default Recognizing weekends and changing to weekdays in Excel

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?