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
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