Forum Discussion
Solved
Age calculation on different END dates
I have a Birth date for individuals, but what to calculate the date they were in different years. Eg 31/12/2008, 31/12/2009 etc. (31 December). the YEARFRAAC is not working, or I'm doing it wrong. a...
Change the number format of the cells with the age formula to General.
here is how it come out my side.
| Births | Age @ | 31/12/2007 | 31/12/2008 |
| 07/03/1990 | 17/01/1900 | 00/01/1900 |
Change the number format of the cells with the age formula to General.
- Thanks that worked!