Dates

[cdanelon]

Is there a way to take an existing date in one cell and add a number of weekdays to it to determine what that date would be. I know you can add the total number of days such as taking 11/30/2017 and add 14 to get to 12/14/17, but what if I wanted to know what the date would be after adding 14 workdays/weekdays. Thanks!

 

[MARK858]

Depends exactly what you mean by weekdays and whether holidays come into it.

The various options are in the link below.

https://www.ablebits.com/office-addins-blog/2015/05/20/excel-workday-networkdays-functions/