Formula for Dates

[nandhamnk]

Hi all,


I required a formula to arrive at exactly correct date before & after the date.

Example:


Date of birth :07-Aug-1983

Exact date before 12 years before birth (Answer) - 22-Jul-1971

Exact date after 4 years from birth (Answer) - 22-Jul-1987


Request your support please!

 

[kaushik03]

Wont it be 8th august'71 (for before 12 years)and 6th' august'87(for after 4 years)


After 4 years: A1+((365.25*4)-1)


before 12 years =A1+((365.25*4)-1)


where A1 is your date.

 

[nandhamnk]

Thanks Kasuhik.Would 365.25 days would be fixed for all the 100 years or it will vary?

 

[vatluri3101]

Won,t it be easier to uae date function like this:

=DATE(YEAR(A1)+4,MONTH(A1),DAY(A1)) to get a date after 4 year and

=DATE(YEAR(A1)-12,MONTH(A1),DAY(A1)) to get a date 12 years in the past?!