Can anyone help with what is no doubt simple formula, but I just can't get the syntax correct for it.
In column A I have numbers 1 to 10 representing years.
In column B I have dates in the format 01/01/2007
I need to take the number in A and add it as years to column B, therefore keeping both the day and month the same.
TIA
Bookmarks