Employee Attendance Tracker / Fiscal Year

%3CLINGO-SUB%20id%3D%22lingo-sub-321040%22%20slang%3D%22en-US%22%3EEmployee%20Attendance%20Tracker%20%2F%20Fiscal%20Year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321040%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20...%20First%20time%20reaching%20out%20to%20a%20community.%20Hope%20someone%20can%20help.%20I%20have%20been%20asked%20to%20put%20together%20an%20attendance%20tracker%20for%20a%20group.%20The%20Excel%20%22Employee%20attendance%20tracker%22%20template%20works%20near%20perfect%20for%20what%20this%20group%20needs%20with%20one%20exception%20they%20need%20it%20to%20show%2Ftrack%20a%20fiscal%20year.%3C%2FP%3E%3CP%3ECan%20the%20formulas%20be%20tweaked%20to%20show%20a%20fiscal%20year%20(example%26nbsp%3B2018%2F2019%2C%202019%2F2020%26nbsp%3B%20etc.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321040%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321193%22%20slang%3D%22en-US%22%3ERe%3A%20Employee%20Attendance%20Tracker%20%2F%20Fiscal%20Year%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321193%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20that's%20possible.%20However%2C%20that%20template%20has%20large%20amount%20of%20formulas%20and%20named%20ranges%2C%20without%20playing%20with%20them%20and%20testing%20I%20afraid%20to%20give%20concrete%20recommendations.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20if%20helps%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Femployee-attendance-tracker%2F5c7e7360-938a-4976-8302-7ed3baa079ec%3Fpage%3D1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Femployee-attendance-tracker%2F5c7e7360-938a-4976-8302-7ed3baa079ec%3Fpage%3D1%3C%2FA%3E%20where%20people%20discussed%20similar%20questions%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

Hi,

 

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