Formula to recognize Fical Year to Reset Paid days off

Gail1954 - Nov 10, 2022 at 03:41 PM
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 - Nov 21, 2022 at 11:25 AM

Hello,

I am trying to make a formula that will choose certain rows from each month in a calendar year that have hours in them, subtract from a total of granted time and when the "year" is up, add the remaining unused days to the newly allotted time for the next year so what is left from the year before is "rolled over" and kept and have the new years' formula take over.  Each employee has a different "beginning" but that date is placed in the same cell in each individual calendar.  I am using "COUNTIF to identify the rows to use and that works, but when I try to tack on additional "IF's" to specify to what point in the calendar to stop subtracting so it will be put to the next year, it stops working.


Windows / Edge 107.0.1418.35

1 reply

TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Nov 21, 2022 at 11:25 AM

Hi Gail,

Could you post some sample data, so it's easier to understand what you are trying to achieve?

Best regards,
Trowa


0