ExcelBanter - start date + net workdays = end date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - start date + net workdays = end date (https://www.excelbanter.com/excel-discussion-misc-queries/236939-start-date-net-workdays-%3D-end-date.html)

oscar

start date + net workdays = end date

I want to caculate the end date which exclude the saturday and sunday, I have
a defined start date plus the working duration(net workdays), and get the end
date. For instance, the project started on 7/14/2009, and work duration is 25
working days, I want to get the this project complte date. anybody has this
formular?

Luke M

start date + net workdays = end date

You are wanting the WORKDAY function. (See XL help file for futher details)

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Oscar" wrote:

I want to caculate the end date which exclude the saturday and sunday, I have
a defined start date plus the working duration(net workdays), and get the end
date. For instance, the project started on 7/14/2009, and work duration is 25
working days, I want to get the this project complte date. anybody has this
formular?

All times are GMT +1. The time now is 05:13 AM.