Home>Blogs>Excel Tips and Tricks>Quick Weekly Attendance Template in Excel
Quick Weekly Attendance in Excel
Excel Tips and Tricks Templates

Quick Weekly Attendance Template in Excel

In this video, we have explained how to create a Quick Weekly Attendance Template in Excel using New Check box feature in office 365 and Conditional formatting.

Follow the below given step to achieve this-

Put the headers:

Add the headers first from Range A3 to I3 as given below

  • Emp Name on A3
  • First letter of the day as S, M, T, W, T, F and S on range B3 to H3
  • Put “Attendance” on range I3

Enter Emp Names:

Put the Employee name on from range A4. We have put here Emp Name from range A4 to A19.

Attendance Template Format
Attendance Template Format

Insert check boxes:

  • Select the range B4:H19
  • Go to insert and insert the check box
  • Take the font size as 8
  • Reduce the column width as 2.5 or 3
  • Take the font color as light green
Insert check boxes
Insert check boxes

Put the Attendance Formula:

  • Put the formula on range I4 as “=COUNTIF(B4:H4,TRU/COUNTA(B4:H4)”
  • Fill this down from I4 till I19
  • change into percentage format using shortcut key Shift+Ctrl+5
Put the Attendance Formula
Put the Attendance Formula

Add Conditional Formatting Data Bar:

  • Select the range I4:I19
  • Press Alt +O+D to open the Conditional Formatting Rule Manager.
  • Click on New Rule
  • Select Format Style as “Data Bar”
  • Select Minimum and Maximum Type as Number.
  • Take Minimum Value as 0 and Maximum value as 1
  • Select Gradient Fill in Fill.
  • Choose Color as orange.
  • Choose Solid Border in Border and Border color as Orange.
Conditional Formatting Window
Conditional Formatting Window
  • Click on OK and Apply the Rule.

Our Quick Weekly Attendance Template in Excel is ready to use.

Weekly Attendance Template in Excel
Weekly Attendance Template in Excel


Visit our YouTube channel to learn step-by-step video tutorials


Watch the step-by-step video tutorial:

Click here to download the practice file

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!