Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how would i use excel to find the number of days-------
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how would i use excel to find the number of days-------
Use the NETWORKDAYS function. See Excel help for details.
Biff "joe hunter" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how would i use excel to find the number of days-------
On Wed, 6 Jun 2007 18:15:00 -0700, joe hunter
wrote: 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find the number of days from 2 dates? | Excel Discussion (Misc queries) | |||
to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
A number of days into weeks and days | Excel Worksheet Functions | |||
Determining the number of specific days between two dates in Excel | Excel Worksheet Functions | |||
Find number of days between to dates | Excel Worksheet Functions |