Forum Discussion
Employee attendance tracker
Riny_van_Eekelen is there a way to change the calendar function to a fiscal year? Our fiscal year runs April 2022 - March 2023. It would be great to have stats from the fiscal year and not calendar year.
You could begin by dragging the first three rows in the table (i.e. B6:AR9) to the bottom so that you will end up with a calendar from April to March. But then you have to increase the year number by 1 in the DATE functions in the first six and last six columns on the bottom three rows.
For instance, cell C15 (January) will then look like this:
=IFERROR(IF(TEXT(DATE(Calendar_Year+1,ROW($A1),1),"ddd")=LEFT(C$5,3),DATE(Calendar_Year+1,ROW($A1),1),""),"")
Otherwise the January row will still refer to 2022 where you want it to be 2023.
It should work but you need to test it thoroughly and I can't guarantee that it will not have any side affects elsewhere. This particular template is built with quit ancient techniques, one of the worst I've seen.