Forum Discussion

KateEC's avatar
KateEC
Frequent Visitor
8 years ago
Solved

Age calculated column

Hi,   I am trying to create a calculated column with age worked out used the 'Birthdate' column. I've looked and tried using some of the formulas from some existing posts, but none have worked.   ...
  • KateEC's avatar
    KateEC
    8 years ago

    Thanks for replying! In the end, I managed to do it using:

     

    Age (Today) = FLOOR(IF([Birthdate] < TODAY(), DATEDIFF([Birthdate], TODAY(), DAY) / 365.25, 0), 1)

     

    Couldn't quite figure yours out (absolute novice, here!), but thanks anyway! :) 

     

     

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

 

KateEC,

 

You may add a calculated column and refer to this post.

 

Column =
IFERROR (
    DATE ( RIGHT ( Table1[Birthdate], 4 ), MID ( Table1[Birthdate], 4, 2 ), LEFT ( Table1[Birthdate], 2 ) ),
    BLANK ()
)

 

KateEC's avatar
KateEC
Frequent Visitor
8 years ago

Thanks for replying! In the end, I managed to do it using:

 

Age (Today) = FLOOR(IF([Birthdate] < TODAY(), DATEDIFF([Birthdate], TODAY(), DAY) / 365.25, 0), 1)

 

Couldn't quite figure yours out (absolute novice, here!), but thanks anyway! :)