Looking at your sheet1 looks like you want to add the number of days in
G3 (5.8) to the date in C3, excluding weekends, If any time on a
working day is acceptable perhaps
=WORKDAY(C3,G3+MOD(C3,1))+MOD(C3+G3,1)
although, depending on your answers to my questions above, you might
need a more complex formula.....
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=475490