| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Calculating Working Days
Can anyone advise me how to calculate the number of working days? Obviously
calculating the number of days between 2 dates is easy, but is there an expression to use which returns the number of working days? Many thanks. Will |
|
#2
|
|||
|
|||
|
Take a look at NETWORKDAYS() function
"will" wrote in message ... Can anyone advise me how to calculate the number of working days? Obviously calculating the number of days between 2 dates is easy, but is there an expression to use which returns the number of working days? Many thanks. Will |
|
#3
|
|||
|
|||
|
Hi Will
check out the NETWORKDAYS function in help ... it's part of the analysis tool-pak add-in Cheers JulieD "will" wrote in message ... Can anyone advise me how to calculate the number of working days? Obviously calculating the number of days between 2 dates is easy, but is there an expression to use which returns the number of working days? Many thanks. Will |
|
#4
|
|||
|
|||
|
=NETWORKDAYS(start_date,end_date,holidays)
holidays is an optional argument to avoid counting holidays. This would be a worksheet range. This function is part of the Analysis Toolpak, so you need that to be installed. -- HTH RP (remove nothere from the email address if mailing direct) "will" wrote in message ... Can anyone advise me how to calculate the number of working days? Obviously calculating the number of days between 2 dates is easy, but is there an expression to use which returns the number of working days? Many thanks. Will |
|
#5
|
|||
|
|||
|
Many thanks everyone.
Will "Bob Phillips" wrote: =NETWORKDAYS(start_date,end_date,holidays) holidays is an optional argument to avoid counting holidays. This would be a worksheet range. This function is part of the Analysis Toolpak, so you need that to be installed. -- HTH RP (remove nothere from the email address if mailing direct) "will" wrote in message ... Can anyone advise me how to calculate the number of working days? Obviously calculating the number of days between 2 dates is easy, but is there an expression to use which returns the number of working days? Many thanks. Will |
|
#6
|
|||
|
|||
|
Other approach (without holidays, calculating from 24:00
of first date to 24:00 of second date): =(A2-WEEKDAY(A2,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY (A1,2))+MIN(5,WEEKDAY(A2,2)) HTH, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Hybrid Mode
