Hello,

I am trying to find a formula which will show the date of a potential student on a certain date e.g 1st August 2014
Cell A2 has the students date of birth
Cell B2 has the students current age

I would like cell C2 to show the students date of birth on the 1st August 2014.

Any help appreciated
Thanks