Calculate dates

[carolynnang]

purple
Hi there.

Please help to provide the functions :

If i have a date : 2 Feb 2002
and I want to find out 7 years from the above date what is the dat
(which is 2 Feb 2009) how can i go about doing so?

i am trying to calculate the years of birth dates.

many thanks
Carolyn

 

[Govind]

Hi Carolynn,

If you have your date in cell A1(for eg), then use this example

=DATE(YEAR(A1)+7,MONTH(A1),DAY(A1))


Regards

Govind.

 

[Bob Phillips]

=date(YEAR(A1)+7,MONTH(A1),DAY(A1)

although 29th Feb 2004 will give 1st Mar 2011

 

[Guest]

Hi,

Use the Date function. Well explained in the Help function

Regards,

Ashish Mathur

 

[Arvi Laanemets]

Hi

To avoid leap year problem, use the formula
=MIN(DATE(YEAR(A1)+7,MONTH(A1),DAY(A1),DATE(YEAR(A1)+7,MONTH(A1)+1,0))


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

=date(YEAR(A1)+7,MONTH(A1),DAY(A1)

although 29th Feb 2004 will give 1st Mar 2011