Ok, so what is the frequency for a retest?

Let's assume the retest is due in 7 days. Just add 7 days to the inspection
date.

A1 = inspection date
B1 = formula

=IF(A1="","",A1+7)

--
Biff
Microsoft Excel MVP


"Scotty" wrote in message
...
I am using Excel 2003 and within a new spread sheet that I am creating I
have
2 cells with dates in them. 1 cell is the date that the equipment was
inspected and the other cell is the date that the equipment needs re
inspection.
When this spread sheet is completed I would like to only change the date
in
the inspection date cell and if available there be a formula to
automatically
change the retest date.