Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workday function
Hoping someone can help.....
Running Excel 2003, do not seem to have "Workday" function available in function list? TIA, Sandi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workday function
Not to be a jerk... but have you tried typing =workday(your arguments
here) in a cell? This is from Help: Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program. Syntax WORKDAY(start_date,days,holidays) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workday function
Make sure that the Analysis Toolpak function is installed.
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "RUSH2CROCHET" wrote in message ... Hoping someone can help..... Running Excel 2003, do not seem to have "Workday" function available in function list? TIA, Sandi |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workday function
ToolsAdd-ins, check Analysis Toolpak
-- Kind regards, Niek Otten "RUSH2CROCHET" wrote in message ... | Hoping someone can help..... | | Running Excel 2003, do not seem to have "Workday" function available in | function list? | | TIA, | Sandi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workday function
To: Dave O, Bob Phillips, Niek Otten:
Thanks for the "Analysis Tool Pak" reminder. I remembered having the funtion previously, however, our organization recently updated to 2003 version, and I had not as yet installed that. Thanks again! Sandi "Dave O" wrote: Not to be a jerk... but have you tried typing =workday(your arguments here) in a cell? This is from Help: Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. How? On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program. Syntax WORKDAY(start_date,days,holidays) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
to use workday function in excel vba code | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |