Forum Discussion

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 03, 2018

Hi Richard,

 

You can use the https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c function as follows:

=DATEDIF(A1,TODAY(),"Y")

 Where cell A1 is the birthdate.

 

Hope that helps

dolive13's avatar
dolive13
Copper Contributor
Jul 22, 2021

Haytham Amairah 

This format did not work for me. Do you know why that would be?

Thanks

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 22, 2021

    dolive13 

    Could you share screenshot or sample file, and what exactly means "not work"?

    • dolive13's avatar
      dolive13
      Copper Contributor
      Jul 23, 2021

      SergeiBaklan  I had existing data ranges filled out with birth dates in them. I wanted the year first and tried formatting this way but the changes never occurred. After giving up on that I still wanted to figure out current age and since I will be looking at this file for years to come I would like it to update automatically.  What function do I use to do this? Thanks

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 23, 2021

        dolive13 

        As variant birthdays are entered as texts which looks as dates, not as values which Excel recognize as dates for your regional settings. Whatever. Why don't you share small sample file?

Resources