Forum Discussion
Age Formula
Hi, I'm looking for some help / advice. I have a spreadsheet which hold details of patients I provide anaesthetic care for. Part of this information includes date of birth, and date of their ...
That's strange - it works OK in Excel for Windows:
But try the following instead:
=YEAR(G3)-YEAR(C3)-(DATE(YEAR(G3), MONTH(C3), DAY(C3))>G3)