Making weekends count

Question

In the online template Employee Attendance Record, how do I make it to were all days of the year are considered workdays.. to include Saturday and Sunday

Answer 1

Dear @Luke B,

In the Employee Attendance Record Excel template, Saturdays and Sundays are excluded by default because the template uses built‑in formulas that treat weekends as non‑workdays.

If you want all days of the year (Monday through Sunday) to be considered workdays, you can update the formulas as follows:

Open the Employee Attendance Record in Excel > if you use formulas like WORKDAY, WORKDAY.INTL, NETWORKDAYS, or WEEKDAY > Replace those formulas with versions that treat all days as workdays.

Weekend string values are seven characters long. Each character in the string represents a day of the week, starting with Monday. The character 1 represents a non-workday and 0 represents a workday. Only the characters 1 and 0 are permitted in the string. Also, 1111111 is an invalid string. For reference: WORKDAY.INTL function

For example, 0000011 would result in a weekend that is Saturday and Sunday. Therefore, if you see WORKDAY, replace it with:

WORKDAY.INTL(start_date,days,"0000000")

Or if you see NETWORKDAYS, replace with. For reference: NETWORKDAYS.INTL function

NETWORKDAYS.INTL(start_date,end_date,"0000000")

I hope the information shared helps point you in the right direction. Please try the steps above and let me know if they work. If not, we can continue working together to narrow this down.

The first response may not always resolve the issue right away, but with your help and more details, we can work toward a solution.

Thank you for your patience and understanding. I'm looking forward for your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

Simply start date + number of days or end date - start date +1