Tue 24 Feb 2009, 16:36Delegate Chrisa said...
Chrisa has attended:
Excel Advanced course
Date
How can you create a function that automatically creates an age from two date fields?
Tue 24 Feb 2009, 21:59Trainer Cress said...
RE: Date
Hello Chrisa
Thank you for your question
Have you tried this formula:
=(B2-A2)/365
You will need to format the column with the formula in it as a number to get the age in years.
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
