Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday calculation - not working
Hi,
I'm trying to make a time and events schedule to track a project's progress. basically in A1 will be the start date, B1 will be the end date, and I want to know the number of workdays, not including weekends it will take to complete this part of the project in C1. I've entered the =WORKDAYS(A1,B1) formula and I keep getting either the #VALUE? or #NAME? response. I've added the Analysis ToolPak ADD-IN so I don't understand why this isn't working - HELP! -- thanks, L |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday calculation - not working
On Tue, 18 Jul 2006 12:23:01 -0700, LOK wrote:
Hi, I'm trying to make a time and events schedule to track a project's progress. basically in A1 will be the start date, B1 will be the end date, and I want to know the number of workdays, not including weekends it will take to complete this part of the project in C1. I've entered the =WORKDAYS(A1,B1) formula and I keep getting either the #VALUE? or #NAME? response. I've added the Analysis ToolPak ADD-IN so I don't understand why this isn't working - HELP! I'm guessing, since you didn't clarify, that you got the #NAME? result before and the #VALUE? result after you added the ATP. You are probably getting bad results because you are using the wrong function, or because your date is really TEXT and not a true date. To determine the number of days between start date and end date, you should be using the NETWORKDAYS function. See HELP for the difference between these two functions. If you get the #VALUE error, then probably your date is TEXT and not an Excel Date. To tell if it is TEXT, try formatting A1 or B1 as General. If the appearance remains that of a date, and does not change to some five digit number, then your value is text. --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday calculation - not working
No such function as WORKDAYS.....WORKDAY........yes........ but not what you
need here. You want NETWORKDAYS function. =NETWORKDAYS(A1,B1) Gord Dibben MS Excel MVP On Tue, 18 Jul 2006 12:23:01 -0700, LOK wrote: Hi, I'm trying to make a time and events schedule to track a project's progress. basically in A1 will be the start date, B1 will be the end date, and I want to know the number of workdays, not including weekends it will take to complete this part of the project in C1. I've entered the =WORKDAYS(A1,B1) formula and I keep getting either the #VALUE? or #NAME? response. I've added the Analysis ToolPak ADD-IN so I don't understand why this isn't working - HELP! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday calculation - not working
Some VBA code which creates a User defined Function. Just code Code Press Alt + F11 Insert Module Paste Code Close VBA Editor Insert Function User Defined and select cells http://www22.brinkster.com/accessory/modules/003.shtml VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562597 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday calculation - not working
I did check the formating of the cells and they were dates (changed to a 5
digit number when I change to general). So, I'm unsure of what my next steps are. the ATP is activated and this is the function I want - the NETWORKDAYS (I tried both that and WORDAY) and yet neither works....ideas? -- thanks, L "Ron Rosenfeld" wrote: On Tue, 18 Jul 2006 12:23:01 -0700, LOK wrote: Hi, I'm trying to make a time and events schedule to track a project's progress. basically in A1 will be the start date, B1 will be the end date, and I want to know the number of workdays, not including weekends it will take to complete this part of the project in C1. I've entered the =WORKDAYS(A1,B1) formula and I keep getting either the #VALUE? or #NAME? response. I've added the Analysis ToolPak ADD-IN so I don't understand why this isn't working - HELP! I'm guessing, since you didn't clarify, that you got the #NAME? result before and the #VALUE? result after you added the ATP. You are probably getting bad results because you are using the wrong function, or because your date is really TEXT and not a true date. To determine the number of days between start date and end date, you should be using the NETWORKDAYS function. See HELP for the difference between these two functions. If you get the #VALUE error, then probably your date is TEXT and not an Excel Date. To tell if it is TEXT, try formatting A1 or B1 as General. If the appearance remains that of a date, and does not change to some five digit number, then your value is text. --ron |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workday calculation - not working
On Tue, 18 Jul 2006 13:33:02 -0700, LOK wrote:
I did check the formating of the cells and they were dates (changed to a 5 digit number when I change to general). So, I'm unsure of what my next steps are. the ATP is activated and this is the function I want - the NETWORKDAYS (I tried both that and WORDAY) and yet neither works....ideas? What does "neither works" mean? Do you get an error message? If so, what message? Post copies of your inputs, formula, actual output, desired output. Do copy/paste in order to avoid typos. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Calculation not working | New Users to Excel | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |