Hi
What is the formula to calculate the number of working days of an employee if:
1) Number of annual leave days is 27
2) The weekend is a Friday and Saturday
Hi
What is the formula to calculate the number of working days of an employee if:
1) Number of annual leave days is 27
2) The weekend is a Friday and Saturday
Hi,
=NETWORKDAYS.INTL(A1,A2,7)-27 where A1 & A2 are the "start date" and the "end date", 27 is the number of leaves.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks