I don't understand the "for my next file" part, but if 7/1 is in A1, then
=A1+5 will give you the date you want. Just remember you have to format both
cells as dates.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"StangThang" wrote in message
...
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.