Hello,
Would appreciate your assistance if you can help me calculate 18 weeks of total vacation accrual in hours from the start date & also broken down by working weeks.
I have attached a file that will better represent the scenario.
Appreciate you help.
Original Hire Date = June 9, 2014
Calculate accrual from Start Date = Oct 29, 2018 to a max of 18 weeks Feb 15, 2019
Total vacation accrued in hours? = Improved formula needed, I coming up with 50 hours.
I also split the 18 weeks individually.
Bookmarks