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
