J
Jfilbig
Need formula to add 3, 5 or 20 days to a start date and exlude sat
sun.
Help please
sun.
Help please
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
Look at the WORKDAY() function, which does just that.
If you get a #NAME error: Tools>Add-ins, check Analysis Toolpak
If you get a #NAME error: Tools>Add-ins, check Analysis Toolpak
H
hansyt
Or maybe: Look at NETWORKDAYS () which excludes weekends and andy
defined holidays.
Hans
defined holidays.
Hans
R
Ron Rosenfeld
Or maybe: Look at NETWORKDAYS () which excludes weekends and andy
defined holidays.
Hans
How do you use NETWORKDAYS to add 10 days to a given date?
--ron
C
Chip Pearson
To add days, use the WORKDAY function.
Ron Rosenfeld said:How do you use NETWORKDAYS to add 10 days to a given date?
--ron
R
Ron Rosenfeld
To add days, use the WORKDAY function.
I know that. I was wondering why Hans was recommending the NETWORKDAYS
function.
--ron