Date calculation

J

Jessica

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Every New Tasks Wants to Start in the Future 1
Display weeks from a Milestone 0
Space at end of multi page list to accommodate new entries 1
Ignore blank cells when calculating date for If, Then function 3
Publisher is filling blank lines with data 2
Calculating a percenatge based on dates 1
MS Project. Real progress of the project, % complete 1
Cell color changes when date gets closer 2

Top