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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|