MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Next work day function


Posted by Ben on August 07, 2000 10:11 PM

Is there a function that returns the next calendar workday?


Posted by Celia on August 09, 0100 1:15 AM

Re: Thanks all

Ben
Go to Tools/Add-ins, select Analysis Toolpak, and click OK. You should then be able to use the shorter formula.
Celia

Posted by Michael Liu on August 08, 0100 1:40 PM

or just =WORKDAY(A1,1)
I think this is part of the Analysis Toolpak Add-in.
Same one that contains the EOMONTH function.

Posted by Ben on August 09, 0100 6:58 PM

Re: Thanks all

Thanks Celia, found it.

Posted by Ben on August 08, 0100 10:41 PM

Thanks all

Long function works. Looks like I can't use the =WORKDAY(A1,1) function yet.

Posted by David on August 07, 0100 11:04 PM

=IF(WEEKDAY($A$1)=7,A1+DAY(2),IF(WEEKDAY($A$1)=6,A1+DAY(3),A1+DAY(1)))

Will return the next weekday. Is that what you want.