Previous Topic Next Topic

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

Related:

1 response

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

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

Hello, I hope whoever reads this message is well!  I’ve been experiencing an issue since before Christmas and I have no idea what to do. When opening Instagram the app, it always tries to get me to update my email address. After doing the app states I won’t have access to some settings for a few days. This has been going on since December, I’ve tried updating my email address on multiple devices to no avail. (See photos) Any guidance/help would be much appreciated. Thank you! 

1 response
You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

Hello,
Tera, you disagreed with the decision
ON 1 MAY 2021
It usually takes us just over a day to review your information. Check again here.

Your account is not visible to people on Facebook and you can't use it.
What happens next
We'll take another look at your account.

If we find that you're old enough, you'll be able to use Facebook again.

If we still find that you aren't old enough to be on Facebook, your account will be permanently disabled, and you won't be able to disagree again.


1 response