Date calculation

Jessica · External Since: Aug 14, 2006 Posts: 63

I have an end date in mind for training, and the number of days the training
is supposed to last. Is there a formula to determine the start date minus
weekends? Example, training must be completed by May 1, 2009, and the
training is supposed to last 10 working days, what should the start date be?

I'm using Excel 2003

Jacob Skaria · External Since: Mar 04, 2009 Posts: 441

With completion date in cell A1 and number of working days in cell B1 ;try
the below formula..Points to be noted

1. Incase this formula returns a #VALUE! error you need to install ATP.
To install; from menu Tools>AddIns> check 'Analysis ToolPak' and hit OK.

2. Format the formula cell to excel date format

=WORKDAY(A1,-B1+1)

If this post helps click Yes
---------------
Jacob Skaria

"Jessica" wrote:

> I have an end date in mind for training, and the number of days the training
> is supposed to last. Is there a formula to determine the start date minus
> weekends? Example, training must be completed by May 1, 2009, and the
> training is supposed to last 10 working days, what should the start date be?
>
> I'm using Excel 2003