Dear daddylonglegs,

Two years later, your formula remains useful. Thanks a lot.

P.B.Mohan

"daddylonglegs" wrote:


If you have a date in A1 and a number of workdays to add in B1...

=INT(B1/6)*7+A1+MOD(B1,6)+INT((WEEKDAY(INT(B1/6)*7+A1)-2+MOD(B1,6))/6)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=530347