A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2003 make 1 date cell automatically change another date cell



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2010, 01:48 AM posted to microsoft.public.excel.worksheet.functions
Scotty
external usenet poster
 
Posts: 69
Default Excel 2003 make 1 date cell automatically change another date cell

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.

  #2  
Old April 22nd, 2010, 02:24 AM posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
 
Posts: 15,759
Default Excel 2003 make 1 date cell automatically change another date cell

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.



  #3  
Old April 22nd, 2010, 03:03 AM posted to microsoft.public.excel.worksheet.functions
Matt Geare[_2_]
external usenet poster
 
Posts: 18
Default Excel 2003 make 1 date cell automatically change another date cell

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.

  #4  
Old April 22nd, 2010, 06:15 AM posted to microsoft.public.excel.worksheet.functions
Scotty
external usenet poster
 
Posts: 69
Default Excel 2003 make 1 date cell automatically change another date

Some of the equipment needs reinspecting every 3 months some every 6 months
and others can be from 12 months to 4 years is there a formula that I can
place in the reinspection date column so that it counteracts with the set
amount of days for each month without been set to a rounded number like 90
days ( eg. Aug = 31 days Sep=30 days Oct=31 days overall = 92 days )

"Matt Geare" wrote:

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.

  #5  
Old April 22nd, 2010, 09:01 AM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default Excel 2003 make 1 date cell automatically change another date

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) for 3 months
--
David Biddulph


"Scotty" wrote in message
...
Some of the equipment needs reinspecting every 3 months some every 6
months
and others can be from 12 months to 4 years is there a formula that I can
place in the reinspection date column so that it counteracts with the set
amount of days for each month without been set to a rounded number like 90
days ( eg. Aug = 31 days Sep=30 days Oct=31 days overall = 92 days )

"Matt Geare" wrote:

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:16 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.