View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Date calculation

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 ToolsAddIns 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