How to calculate dates

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

How would I calculate a project date 60 days from any given date that
includes weekends and holidays. The function will only calcuate weekdays.
 
<includes weekends and holidays>

I assume you mean exclude?

<The function will only calcuate weekdays>

Which function?

Look in HELP for the WORKDAY() function
 
No it has to include weekends and holidays. I'm using the workday function,
which excludes weekends and holidays, and I need to figure out dates that are
60 calendar days from the date of initiaton.

A1 B1
C1

today's date 60 (calendar days) = date project to be
completed
 
If you want only weekdays, use the WORKDAY function.
If you want 60 days on, regardless of weekends and holidays, use =A1+60.
 
Back
Top