So, I wanted to claculate age from user birthdate to current date in Google sheet in my expected format. I tried few formula's from some sources, but it is just not happening.

Can anyone please guide me?

For reference and test purpose, I'm attaching one Google sheet public link. No worries if email address will be shown in Googe sheet.

Link:

to make it smart use:

=INDEX(JOIN(" ", LAMBDA(a, LAMBDA(x, IF(x=0,,IF(x>1, x&a&"s", x&a)))
 (DATEDIF(A2, NOW(), {"Y", "YM", "MD"})))({" year", " month", " day"})))