Formula to recognize Fical Year to Reset Paid days off

Closed
Gail1954 - Nov 10, 2022 at 03:41 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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