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.