Prev: how do i create a repeating student certificate using excel
Next: logical (if a1=specific word, can c1 = value entered in a2?)
From: Scotty on 21 Apr 2010 20:48
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.

From: T. Valko on 21 Apr 2010 21:24
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" <Scotty(a)discussions.microsoft.com> wrote in message
news:56901B1D-C12B-444C-99D7-6C66AED45CA0(a)microsoft.com...
>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.
>


From: Matt Geare on 21 Apr 2010 22:03
Hi Scotty,

This is possible. At it's simplest if the retest date is 100 days later the
formula in the retest date cell would be = inspection date cell + 100.

There are many date related functions that can be used to refine this
process, for example EOMONTH which is useful for returning dates at the "End
of the Month".

If you would like to be more specific about the relationship between the
inspection date and the retest date I'm sure you will find additional help
here, else you might want to explore the date related functions on your own.

All the Best,

Matt

"Scotty" wrote:

> 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.
>
 | 
Pages: 1
Prev: how do i create a repeating student certificate using excel
Next: logical (if a1=specific word, can c1 = value entered in a2?)