I am bulding a spreadsheet that needs to show the new accrual. An emplkyee receives 80 hours of sick for the year on their hire date
A2 has the date, B2 has the hire date I need c2 to show the 80 hours when they reach their anniversary date
I am bulding a spreadsheet that needs to show the new accrual. An emplkyee receives 80 hours of sick for the year on their hire date
A2 has the date, B2 has the hire date I need c2 to show the 80 hours when they reach their anniversary date
Hi d.gmoez,
Welcome to the forum.
Try using below formula:-
Formula:Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks