Eduardo, thank you. That was so simple, I almost feel embarassed.


"Eduardo" wrote:

Hi Pat,
If it has to include weekends and Holidays just do

=A1+60

"Pat" wrote:

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


"Niek Otten" wrote:

<includes weekends and holidays

I assume you mean exclude?

<The function will only calcuate weekdays

Which function?

Look in HELP for the WORKDAY() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Pat" wrote in message
...
How would I calculate a project date 60 days from any given date that
includes weekends and holidays. The function will only calcuate weekdays.