Forum Discussion
cha2812
Jul 01, 2023Copper Contributor
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...
Riny_van_Eekelen
Jul 01, 2023Platinum Contributor
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.
cha2812
Jul 01, 2023Copper Contributor
| 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.
- Riny_van_EekelenJul 01, 2023Platinum Contributor
- cha2812Jul 02, 2023Copper ContributorI do not mean to sound like a broken record but I still get #Value! despite using the formula you provided
- Riny_van_EekelenJul 02, 2023Platinum Contributor
cha2812 Even in the file I uploaded?