Home |
Search |
Today's Posts |
#1
|
|||
|
|||
6 months of working days
Hi,
I'm trying to figure out how to calculate what 6 months of working days would be. I've tried the various Networkdays formating, perhaps I'm using the wrong format for this. Can anyone help? -- Thanks! -Jennifer |
#2
|
|||
|
|||
6 months of working days
You need to have set dates, assume in 01/01/05 in A1 and 06/30/05
in B1 =NETWORKDAYS(A1,B1,Holidays) -- Regards, Peo Sjoblom "Jennifer" wrote in message ... Hi, I'm trying to figure out how to calculate what 6 months of working days would be. I've tried the various Networkdays formating, perhaps I'm using the wrong format for this. Can anyone help? -- Thanks! -Jennifer |
#3
|
|||
|
|||
6 months of working days
=NETWORKDAYS("12/10/05","20/10/05")
usually works for me that would give the result 7 You can replace the "12/10/05" with cell references/formulas to get the same result e.g. =NETWORKDAYS(R14,R15) where R14 = 12/10/05 and r15 = 20/10/05 "Jennifer" wrote: Hi, I'm trying to figure out how to calculate what 6 months of working days would be. I've tried the various Networkdays formating, perhaps I'm using the wrong format for this. Can anyone help? -- Thanks! -Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Working time and days | Excel Discussion (Misc queries) | |||
Calculating Working Days | Excel Worksheet Functions |