If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Add 5 working days | Trying2Learn | General Discussion | 1 | June 20th, 2005 12:52 PM |
working days calcualation | Rick B | Running & Setting Up Queries | 2 | December 22nd, 2004 05:02 PM |
What is wrong w/ this query? | Tom Ellison | Running & Setting Up Queries | 3 | November 19th, 2004 12:30 AM |
No of months and days between 2 dates | Lance | Running & Setting Up Queries | 2 | November 1st, 2004 10:56 PM |
formula to Adding to working days | Suddes | General Discussion | 3 | July 30th, 2004 10:33 AM |