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...
cha2812 That function works just like it does on the PC. Perhaps one of your dates (or both) are texts that just look like dates. That would trigger a #VALUE! error. Nothing Mac specific.
| 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?