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
pdvsaProject financeAsked:
Who is Participating?
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
No, it adds 59 working days. This is what you want:

=WORKDAY(DATE(2015,6,30)+60-1,1,Holidays_US_Jap)
0
 
pdvsaProject financeAuthor Commented:
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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.