E Eán Feb 20, 2009 #1 Hi Is there anyway I can add working days to a date? For example: 23-Feb-09 + 10 = 06-Mar-09 Thanks
M Mike H Feb 20, 2009 #2 Hi, Try this =workday(A1,10,Holidays) The last argument 'Holidays' is an optional named range that includes the dates of any holidays you want included in the calculation. Mike
Hi, Try this =workday(A1,10,Holidays) The last argument 'Holidays' is an optional named range that includes the dates of any holidays you want included in the calculation. Mike
M Mike H Feb 20, 2009 #3 I forgot to mention, If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Tools|Addins Mike
I forgot to mention, If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. Tools|Addins Mike
J JE McGimpsey Feb 20, 2009 #4 Perhaps you better explain what you mean by "working days". 23 Feb 09 -> 6 Mar 09 is a span of 11 TOTAL days. Which day isn't worked? If you mean to exclude Saturdays and Sundays: A1: 23 Feb 09 A2: =WORKDAY(A1,10) will return 9 Mar 09 in A2.
Perhaps you better explain what you mean by "working days". 23 Feb 09 -> 6 Mar 09 is a span of 11 TOTAL days. Which day isn't worked? If you mean to exclude Saturdays and Sundays: A1: 23 Feb 09 A2: =WORKDAY(A1,10) will return 9 Mar 09 in A2.
