I have a date that someone is leaving the company, say October 1. They have 50 hours of vacation that still needs to be paid out. I need to be able to find out what date would be the end date after the 50 hours. I tried using the WORKDAY function, but it doesn't work using an 8 hour day. For example, if they had 48 hours of vacation, it gives me the date of 10/9, which is correct. But, if there are 50 hours of vacation, it still gives me 10/9 and I need to to give me 10/10 since those 2 extra hours would actually fall into the next workday.
Thanks!
Amy
Bookmarks