Excel 2003 make 1 date cell automatically change another date
in [Functions]
|
Prev: Installing service reminder popup windows in excel
Next: combine multiple spreadsheets into one workbook
From: Scotty on 22 Apr 2010 01:15 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. > >
From: "David Biddulph" groups [at] on 22 Apr 2010 04:01
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)) for 3 months -- David Biddulph "Scotty" <Scotty(a)discussions.microsoft.com> wrote in message news:C7AEE17E-74E6-40E1-9CB9-167DFAB002C1(a)microsoft.com... > 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. >> > |