Excel 2003 formula to calculate date

S

StangThang

I need a formula to use to figure out dates automatically. Example, my start
date is 7/1/05 and the due date is 5 days. I need a formula that will let me
change the 7/1/05 date and recalcuate the 5 days for my next file.
 
A

Adam Molinaro

I could be wrong, but I am guessing you actually just want business days,
since you're adding 5. That being the case, you may want to incorporate
NETWORKDAYS, which comes via one of the Add-Ins (Tools > Add-Ins...), I think
either Analysis Toolpak or Solver Add-In. You can account for weekends and
holidays. You could also use some If statements with the WEEKDAY function.

Again, I'm just guessing, as I have had the same need in the past.

Adam.
 
N

nicole

I'm using Excel 2003 to track a project. There are several cells with
formulas to calculate # of days prior to a set target date.

For example if I want to initiate an action 10 days prior to the target
date my cell reads "=A4-10" and it supplies the date. Is there a way
to have this calcuate in business days verses calendar days?
 
T

Tom Ogilvy

the analysis toolpak (shipped with excel - so likely it is installed) offers
the workdays function. See Excel help for details.
 
Top