how would i use excel to find the number of days-------

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how would i use excel to find the number of days from a start date to an end
date excluding weekends and holidays?
example

start date number of days between end date
 
how would i use excel to find the number of days from a start date to an end
date excluding weekends and holidays?
example

start date number of days between end date
Click to expand...

Use the NETWORKDAYS function.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron
 
Back
Top