Joan has attended:
Excel Introduction course
Calculate age formula
How do I enter date of birth, then find age at various dates from today onwards
RE: Calculate age formula
Hi Joan
Enter your date of birth into cell A1 in this format 00/00/0000, replace the 0 with your actual DOB
In cell A2 enter a future date.
In cell A3 enter this formula =A2-A1
In cell A4 enter this formula =A3/365.25
You can now enter any date into cell A2 and excel will calculate your age at that given date.
Does that help?
Kind Regards
Paul