Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workdays Formula
I am trying to create a formula so that I will enter a date in one cell (ex.
Oct 11, 2006), I would then like another cell to take this date and add 3 workdays and therefore be October 16, 2006 (so it doesnt count the weekends). I am not sure if this is possible, but any help would be appreciated. Thanks, Shannon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Workdays Formula
Shannon, use workday, like this, with date in A1 =WORKDAY(A1,3) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Shannon" wrote in message ... I am trying to create a formula so that I will enter a date in one cell (ex. Oct 11, 2006), I would then like another cell to take this date and add 3 workdays and therefore be October 16, 2006 (so it doesnt count the weekends). I am not sure if this is possible, but any help would be appreciated. Thanks, Shannon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |