count number of workdays from a start date

[asmith]

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

[watersev]

hi asmith, option

[sandiptemkar]

Hi,

Some inputs my side,

Use the below formula

=WORKDAY(A3,ROUNDUP(B3/8,0))

Sandeep

[asmith]

Thank you! Both answers were helpful!