Employee Attendance Tracker / Fiscal Year

Occasional Visitor

Hello ... First time reaching out to a community. Hope someone can help. I have been asked to put together an attendance tracker for a group. The Excel "Employee attendance tracker" template works near perfect for what this group needs with one exception they need it to show/track a fiscal year.

Can the formulas be tweaked to show a fiscal year (example 2018/2019, 2019/2020  etc.)

1 Reply



I guess that's possible. However, that template has large amount of formulas and named ranges, without playing with them and testing I afraid to give concrete recommendations.


Please check if helps https://answers.microsoft.com/en-us/msoffice/forum/all/employee-attendance-tracker/5c7e7360-938a-497... where people discussed similar questions