I've created a leave application system. When employees apply for leave, they fill out the start date and end date of their leave. I want the program to automatically calculate the total number of working days for the leave application. For example, if the start date is Friday, 11/29, and the end date is Monday, 12/9, although there are 11 days in between, the actual working days are only 7. How can I write a formula to make the program calculate 7 working days? Thanks.
LinkedIn
Twitter
