Forum Discussion
YEARFRAC does not work for me on mac
I do not know but for some reason, the YEARFRAC function that calculates age does not work in my Excel on mac, it returns the #Value! in my excel. Does anyone experience this and how did they solve t...
| Calculate Age in Excel | 15/01/2023 |
| Date of Birth | Age |
| 28/10/2006 | |
| 20/01/1995 | |
| 23/05/2015 | |
| 01/01/2000 | |
| 28/09/1992 | |
| 21/04/1991 | |
| 03/05/1995 | |
| 22/08/1962 |
I still get the #Value! so if possible could you show me how to correct this error.
- I do not mean to sound like a broken record but I still get #Value! despite using the formula you provided
cha2812 Even in the file I uploaded?
- yes unfortunately