Ask a new question

Employee Attendance Record Template - Days Off

Good day,

I have downloaded within Microsoft Office Professional Plus 2016 Excel, the "Employee Attendance Record", and added all my staff. Although all staff work different days of the week. Is it possible to indicate which days of the week should be counted on the 'Calendar View' tab for each individual rather, than only Saturday and Sunday for all?

Example:

Employee 1 workdays Monday through Friday

Employee 2 workdays Monday, Wednesday and Saturday

Employee 3 workdays Wednesday through Friday

So on...

Thank you for your time,

Castle

it possible to indicate which days of the week should be counted on the 'Calendar View' tab for each individual rather

with the template buildin calculation，it is not easy to count number of Working day with customized holiday。

if need streamline or automate calculation，I guess you need build your own calendar。

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I would be OK removing the number of Working Days. For my needs, I am tracking the days off, rather than the days onsite. In that case, would it be possible to proceed and if so, how might I go about doing that?

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

https://answers.microsoft.com/en-us/msoffice/forum/all/excel-userform-calculating-dates/f86d8d40-f2d2-4bf7-a9c0-478ea6d96f78

in fact,I record very detail day onsite in a list and show in calendar view.

list like:

work_day worker

2022-11-20 Peter

2022-11-22 Peter

2022-11-23 Alice

http://e.anyoupin.cn/ceshi/jstest/pull_up_demo.php?s=calendar

calendar view is kind to read。

but list data stucture is easy to write sql for calculation

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 13, 2025 Views 691 Applies to: