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,

Dan Young

Copper Contributor

May 08, 2017

Hi,

I run a department of around 40 colleagues, many of which have different days off. I would like to use this template but im not sure how i can implement it for each colleagues days off.

Any help would be greatly appreciated

Dan

kishorvijayKV
Copper Contributor
Jun 04, 2023
Do we have a work around for this one ? I am also looking for custom options to pick /assign working days for employees / week off for specific employees
- peiyezhu
  Bronze Contributor
  Jun 04, 2023
  Can you give some.dummy data and expected result?
  what do you mean
  pick /assign working days ?
  - kishorvijayKV
    Copper Contributor
    Jun 04, 2023
    peiyezhuThanks for your quick reply. For example, Employee1 works all 5 days (Mon-Fri), Employee2 works Saturday and Sunday and will avail week off on other two week days. I would like to have an option to customize workdays for employees accordingly .
TrBriggs
Copper Contributor
Jan 19, 2023
Has anyone found a solution for this? I am also currently looking to incorporate my rotating schedule to the template. Thank you