Calculate the Date After A Specified Number of Workdays In Excel


1410051If you use Excel to project manage then you will know that most people work a five day week – Monday to Friday (if they are lucky).  So if you have a project start date and the number of days it will take to complete then if you just added the number of days to the start date, it would not take into account the weekend days in your project.

By using the =WORKDAY() formula allows you to specify a beginning date, the number of workdays until the end of the project.

An example.

My VBA project has a start date of 01 July 2013 and I know it will take 56 days of resources.

So, as you can see below I have entered into cell C5 the formula =WORKDAY(C3,C4) which calculates 56 workdays or Monday though Fridays for 56 days.

1274338

 

 

Excel has therefore calculated  my estimated finish date which is 17 September 2013- EASY!

 

 

 

 More Excel Tips

 

Update Your Excel Skills

Excel Expert Course

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts