G Guest Jul 20, 2006 #1 i wish to have a1=today() b1 = # and c1 return the working days forward. ie. july 1 2006 15 july 21 2006
i wish to have a1=today() b1 = # and c1 return the working days forward. ie. july 1 2006 15 july 21 2006
G Guest Jul 20, 2006 #2 Try this: A1: (a date) B1: (the number of workdays to increment A1 by) C1: =WORKDAY(A1,B1) Per Excel Help: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Does that help? *********** Regards, Ron XL2002, WinXP
Try this: A1: (a date) B1: (the number of workdays to increment A1 by) C1: =WORKDAY(A1,B1) Per Excel Help: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Does that help? *********** Regards, Ron XL2002, WinXP
G Guest Jul 20, 2006 #3 that is the syntax that i used however it returns and error and corrects it to work days(a1,b1) and returns and error of #rem
that is the syntax that i used however it returns and error and corrects it to work days(a1,b1) and returns and error of #rem
G Guest Jul 20, 2006 #4 Hmmm... First, make sure the Analysis TookPak is engaged: <tools><add-ins> Analysis TookPak should be checked. If the ATP is active...check your auto-correct settings and see if they automatically change "workday" to "work days" <tools><options><spelling tab> Click the [AutoCorrect Options...] button Does that help? *********** Regards, Ron XL2002, WinXP
Hmmm... First, make sure the Analysis TookPak is engaged: <tools><add-ins> Analysis TookPak should be checked. If the ATP is active...check your auto-correct settings and see if they automatically change "workday" to "work days" <tools><options><spelling tab> Click the [AutoCorrect Options...] button Does that help? *********** Regards, Ron XL2002, WinXP
