need Formula to enter future date

[SBURTON]

I need a bit of help. I would like to have a date appear in column H3 based on the est hours in column F3 and using 7.5 work hours/day (from E3) and figuring this end date from the start date I manually put in G3. The other issue I see is I would like it to avoid the weekend days in the final H3 date. I hope someone can think of a formula to do this. I have attached my sample spreadsheet.

Thanks

[Ace_XL]

Take your pick..

=WORKDAY(G3,F3/7.5) will give you result assuming no work is carried out on weekends at all and end date is not a weekend.

=WORKDAY(G3+F3/7.5,0) will give you result assuming work is carried out on all weekends, however end date is not a weekend

[daddylonglegs]

=WORKDAY(G3+F3/7.5,0) will give you result assuming work is carried out on all weekends, however end date is not a weekend

WORKDAY with zero workdays to add can return a Saturday or Sunday - for that version you'd need something like

=WORKDAY(G3+F3/7.5-1,1)

....although I imagine the first formula will suit the requirement......

[Ace_XL]

WORKDAY with zero workdays to add can return a Saturday or Sunday - for that version you'd need something like

=WORKDAY(G3+F3/7.5-1,1)

Good catch DLL. Spot on!

[SBURTON]

Perfect, thanks