Thread
:
Working out age from "Day" "Month" "Year"
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
[email protected]
Posts: n/a
Working out age from "Day" "Month" "Year"
Try this, it has worked for me.
=YEAR(TODAY()-DATEVALUE(A1&B1&C1))-1900
Reply With Quote