Entering Ages

Hi Sarah,

Thank you for your question.

I can't think of a method at the moment of getting the cell to update automatically in a years time.

In another cell you could use the following function to add a year to an existing date:

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

This formula will add a year to a date in cell A1. So if A1 was 11/12/09, the result would be 11/12/2010.

I hope this answers your question.

Regards

Simon