| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate A Date Excluding Weekends And Holidays
I have a date and a series of tasks that need to be completed by a certain number of days from the intial date. The time to complete the tasks can not include weekends or holidays. Example: Initial date is 2/15/2006 I have 10 business days to complete a task All Help will be appreciated. Thank you. -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate A Date Excluding Weekends And Holidays
=WORKDAY(A1,10)
Format as date -- Kind regards, Niek Otten "travelersway" wrote in message news:travelersway.22wy5a_1139406608.6858@excelforu m-nospam.com... I have a date and a series of tasks that need to be completed by a certain number of days from the intial date. The time to complete the tasks can not include weekends or holidays. Example: Initial date is 2/15/2006 I have 10 business days to complete a task All Help will be appreciated. Thank you. -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate A Date Excluding Weekends And Holidays
NIEK, =WORKDAY(A1,10) I tried that formula and the results came up as NAME. Any suggestiond?Thanks, TRAVELERSWAY -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate A Date Excluding Weekends And Holidays
Sounds like you're missing the Analysis TookPak Add-in. Excel's Help on the WORKDAY function says the following: 1. On the Tools menu, click Add-Ins. 2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. 3. If necessary, follow the instructions in the setup program. -- taylorm ------------------------------------------------------------------------ taylorm's Profile: http://www.excelforum.com/member.php...o&userid=28892 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate A Date Excluding Weekends And Holidays
TAYLORM, I followed your suggestion. I now receive the same day but an extended year: calculated date of 2/15/*20 *. I am using a custom format for the date; xx"/"xx"/"xx will this affect the results? Thank you for your help. TRAVELERSWAY. -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate A Date Excluding Weekends And Holidays
When I changed mine to a Custom format of xx"/"xx"/"xx as you said, it displayed xx/xx/xx. So I'm not sure exactly what you're trying to do there.  I have 2/15/2006 in cell A1, with a normal Date type format. In cell B2 I have the following formula: =WORKDAY(A1,10) to add 10 working days to 2/15/2006. The result in cell B2 (with the same Date type format as cell A1) shows 3/1/2006. -- taylorm ------------------------------------------------------------------------ taylorm's Profile: http://www.excelforum.com/member.php...o&userid=28892 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate A Date Excluding Weekends And Holidays
Yes, to make sense WORKDAY needs a date entered with delimiters like
02/01/06 for Feb 2006 using US settings or it needs the conversion whatever that might be depending on how you enter "dates" Note that it is always better to enter dates that excel can recognize instead of enter pseudo dates that one has to convert to excel dates -- Regards, Peo Sjoblom Portland, Oregon "travelersway" wrote in message news:travelersway.22x7vb_1139419202.7497@excelforu m-nospam.com... TAYLORM, I followed your suggestion. I now receive the same day but an extended year: calculated date of 2/15/*20 *. I am using a custom format for the date; xx"/"xx"/"xx will this affect the results? Thank you for your help. TRAVELERSWAY. -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php...o&userid=17623 View this thread: http://www.excelforum.com/showthread...hreadid=510032 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Calculate A Date Excluding Weekends And Holidays | New Users to Excel | |||
| Workday With Weekends Excluding Holidays | Excel Worksheet Functions | |||
| How do you count work days excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Formula - Excluding weekends & holidays | Excel Worksheet Functions | |||
Hybrid Mode
