how to calculate a date 3 yrs on

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me please?

I am working from a Table. First Column is the Training Date and the 2nd
column is to be a calculation of the training date + 3 years.

1st column is staff's H&S certificate updated course date.
2nd column is for a calculation of 1st column Training Date + 3 yrs.
Certificates are updated every three years.

I did try =DateAdd ("y", 3 "16/10/2003") and =DateAdd ("y", 3 [Training
Date]) .

Next date should be calculated at 16/10/2006.

Please help.

Kim Johnson.
 
I am working from a Table. First Column is the Training Date and the 2nd
column is to be a calculation of the training date + 3 years.

1st column is staff's H&S certificate updated course date.
2nd column is for a calculation of 1st column Training Date + 3 yrs.
Certificates are updated every three years.

I did try =DateAdd ("y", 3 "16/10/2003") and =DateAdd ("y", 3 [Training
Date]) .

Next date should be calculated at 16/10/2006.

Please help.

Kim Johnson.
Click to expand...

A single y is for day of the year (1 - 365). To add years, use yyyy and
separate the number of years from the starting date with a comma like so:

=DateAdd ("yyyy", 3, "16/10/2003")

Tom Lake
 
Back
Top