Forum Discussion

Raghavendra Bhat's avatar
Raghavendra Bhat
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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 29, 2017

Hi,

 

Calculating working days of the year template uses NETWORKDAYS function in the formula. You shall change it on NETWORKDAYS.INTL with proper parameters https://support.office.com/en-us/article/NETWORKDAYS-INTL-function-a9b26239-4f20-46a1-9ab8-4e925bfd5e28.

 

In addition, template grays Sat and Sun using Conditional formatting, within the rule formula you'll find

LEFT(C$5,1)="S"

Just change it on

C$5="SUN"

Use it selecting all days in the table

  • Haidar Habibie's avatar
    Haidar Habibie
    Copper Contributor
    Oct 12, 2018

    Hi Sergei.

     

    How if I want to categorize who are employees that get Sat & Sun Holiday and who are employees that only get Sun for Holiday using conditional formatting?

    Kindly need your help ASAP.

Resources