Forum Discussion

Copper Contributor

Apr 29, 2017

Employee attendance tracker using excel

Hi, I need to make saturday as working day. The below template in excel 2016 has Saturday and Sunday and weekend. How can i change this ? https://templates.office.com/en-us/Employee-attendance-trac...

excel

Haytham Amairah

Silver Contributor

Apr 29, 2017

Dear,

Go to the Conditional Formatting Rules Manager, and select the last rule.

If you want the weedend to be Friday & Saturday, replace that formula by this one:

=OR(LEFT(C$5,2)="FR",LEFT(C$5,2)="SA", COUNTIF(lstHolidays, C6)>0)

Or, if you want it to be Friday only or Saturday, use this:

For Friday:

=OR(LEFT(C$5,2)="FR", COUNTIF(lstHolidays, C6)>0)

For Saturday:

=OR(LEFT(C$5,2)="SA", COUNTIF(lstHolidays, C6)>0)

Hope you find this information useful!

Regards,

Noctis Fate

Copper Contributor

Mar 08, 2018

In my country Saturday and Sunday are counted in your "vacation" time frame. I see that you show how to select different dates for weekends, but I need the chart to count all days to be working days. So that the vacation count on the "Calendar View" and "Employee Leave Tracker" Show the correct amount of dates.

For example I have logged in the "Employee Leave Tracker" Employee 1 Start date Jan 29, 2018, End Date Feb 23rd, 2018; it counts as 20 days when I want it to count as 26 days (Including Sat and Sun).

Appreciate your help,

Thanks in advance.