Wednesday 1 April 2015

Count working days (Excluding SAT,SUN)

Count working starting after specific date (Excluding SAT,SUN)
 
 
For example specific date is 4/1/2015 and days to add is 12. Use below formula
 
=WORKDAY.INTL(H89,I89,1) the output is  4/17/2015
 
 
Count working starting from specific date (Excluding SAT,SUN)


For example specific date is 4/1/2015 and days to add is 12. Use below formula

=WORKDAY.INTL(H89,I89,1)-1 the output is 4/16/2015
 
 

No comments:

Post a Comment