Link to home
Start Free TrialLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

Workdays - 60 from June 30

Does the below add 60 calendar days (not workdays) but if the date falls on a weekend then move it to the workday?  I also need to incorporate the holidays.  

=WORKDAY(DATE(2015,6,30),60-1,Holidays_US_Jap)

thank you
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pdvsa

ASKER

so I think the main difference is whether or not there is a comma before the days criteria.  

with a comma = calendar days (not business)
without a comma is business days.

is that correct?