Calculate Project dates
 

I need to calculate a project date 60 days from any given date, but the
formula will only let me do weekdays. I need to do 60 calendar days
including holidays.

Calculate Project dates
 

Hi,
if your date is in cell A1 and you want the result in B1 enter

=A1+60

"Pat" wrote:

I need to calculate a project date 60 days from any given date, but the
formula will only let me do weekdays. I need to do 60 calendar days
including holidays.

Calculate Project dates
 

Opps, I misunderstood your question, use

=WORKDAY(A1,60)

"Eduardo" wrote:

Hi,
if your date is in cell A1 and you want the result in B1 enter

=A1+60

"Pat" wrote:

I need to calculate a project date 60 days from any given date, but the
formula will only let me do weekdays. I need to do 60 calendar days
including holidays.