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...
yes unfortunately
Oviously my own file works on my Mac. Can you upload a screenshot showing the formula and #VALUE! error in B3, similar to my screenshot below?
- Thank you very much it has worked, the reason for the error was that i was inputting the date format wrongly and so did not work.