Prev: VLOOKUP with WORKDAY?
Next: Spread numbers by setting up a Min and Max
From: Jessica on 2 Nov 2009 04:14
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
From: Jacob Skaria on 2 Nov 2009 04:40
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
 | 
Pages: 1
Prev: VLOOKUP with WORKDAY?
Next: Spread numbers by setting up a Min and Max