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  

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies