Forum home » Delegate support and help forum » Microsoft Excel Training and help » Entering Ages
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Entering Ages
Resolved · Medium Priority · Version 2003
Reply Tue 17 Nov 2009, 16:28Delegate Sarah said...
Sarah has attended:
Excel Advanced course
Entering Ages
How do you enter an age and then it is updated yearly?
For upcoming training course dates see: Pricing & availability
RE: 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
Tue 24 Nov 2009: Automatically marked as resolved.
|