How to calculate age from date of birth in google spreadsheet?

Question

Google Sheets

You need to calculate the age based on the date of birth.

What formula does this? So that the calculation is automatic, without entering the current date, and Google pulls it up from its actual date on the calendar.

Answer 1

Better this way, otherwise there may be problems due to leap years next to the birthday:
=РАЗНДАТ(A1;СЕГОДНЯ();"Y")

Answer 2

In A1 enter the date of birth
in B1 enter
=(СЕГОДНЯ()-A1)/365