Tuesday, 15 October 2013

Add a number of working days to a date - workdays formula - Excel

You can calculate a date in excel relative to a starting date +/- a number of working days

= workdays ( Date , +/- number of working days )

Example table



Add a number days to a date - Excel

Alternatively if you need to determine the figure based on all days (not working days) you can simply +/- a number of days from a starting date

= Date  +/- number of working days