Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating number of days
I have two columns with date filled in. For example one of
the columns has a date of 02/23/05 the second columns has a date of 03/01/05. What I need is to calculate the number of day between the two dates minus the weekend days. Can anyone help me. |
#2
|
|||
|
|||
Check out the NETWORKDAYS worksheet function in Excel
Help. HTH Jason Atlanta, GA -----Original Message----- I have two columns with date filled in. For example one of the columns has a date of 02/23/05 the second columns has a date of 03/01/05. What I need is to calculate the number of day between the two dates minus the weekend days. Can anyone help me. . |
#3
|
|||
|
|||
Look at NETWORKDAYS, you need to have ATP installed but it comes with
excel/office =NETWORKDAYS(start,end,holidays) could look like =NETWORKDAYS(A1,B1,H2:H10) -- Regards, Peo Sjoblom "Carlos" wrote in message ... I have two columns with date filled in. For example one of the columns has a date of 02/23/05 the second columns has a date of 03/01/05. What I need is to calculate the number of day between the two dates minus the weekend days. Can anyone help me. |
#4
|
|||
|
|||
Take a look at the NETWORKDAYS function, which needs the Analysis Toolpak to
be installed. -- HTH RP (remove nothere from the email address if mailing direct) "Carlos" wrote in message ... I have two columns with date filled in. For example one of the columns has a date of 02/23/05 the second columns has a date of 03/01/05. What I need is to calculate the number of day between the two dates minus the weekend days. Can anyone help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating the number of Fridays in a month | Excel Worksheet Functions | |||
Count number of days in given month? | Excel Worksheet Functions | |||
Calculating interest on number of days in the period | Excel Worksheet Functions | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |