I need to add lead times (3 days, 6, days, 11 days, 16 days) to entered dates. The resulting date cannot be a Sat. or Sun., only workdays. Any ideas?
I need to add lead times (3 days, 6, days, 11 days, 16 days) to entered dates. The resulting date cannot be a Sat. or Sun., only workdays. Any ideas?
check out the NETWORKDAYS formula
"mhart210" wrote:
>
> I need to add lead times (3 days, 6, days, 11 days, 16 days) to entered
> dates. The resulting date cannot be a Sat. or Sun., only workdays.
> Any ideas?
>
>
> --
> mhart210
> ------------------------------------------------------------------------
> mhart210's Profile: http://www.excelforum.com/member.php...o&userid=26413
> View this thread: http://www.excelforum.com/showthread...hreadid=396847
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks