| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 9078 | 2001-05-06 00:00:00 | Calculating Age | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 12215 | 2001-05-06 00:00:00 | After entering a birthdate, I would like to create a formula to calculate a persons age (in years) as at the current date. | Guest (0) | ||
| 12216 | 2001-05-06 01:22:00 | Murray, To calculate age, use the formula =(NOW()-A1)/365, where A1 is their date of birth (dd/mm/yyyy). To calculate their age from only the year of birth, use the formula =YEAR(NOW())-A1, where A1 is their year of birth (yyyy) |
Guest (0) | ||
| 1 | |||||