![]() |
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 |
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 |
All times are GMT +1. The time now is 03:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com