Skip to main content

Age years & months from 'date of birth'

  • January 18, 2018
  • 2 replies
  • 41 views
S
  • Sam_Gray
  • Participating Frequently
  • 5 replies

Hi all,

I’ve got a column for ‘date of birth’.
I’m looking for a formula that will input their age in months and years. (At the moment, it will only let me do one of these)

DATETIME_DIFF(TODAY(), {D of B}, ‘years’)

I then plan to add an IF statement along the line of (if months = 11 show an alert) so I remember to send a card.

Thank you for any help

    2 replies

    A
    Forum|alt.badge.img+18
    • Andre_Zijlstra
    • Inspiring
    • 166 replies
    • January 18, 2018

    @Sam_Gray I think you can solve this by adding another field with the name “Months”.

    The formula in that field would be:
    DATETIME_DIFF(TODAY(),{Date of Birth},‘months’)-Years*12

    So, you substract the sum of Years * 12 from the total amount of months that is calculated by the formula.

    Then, in the last field you add a formula to promt a message as soon as the value “11” is reached:
    IF(Months=11,“ :balloon: SEND A CARD”,BLANK())

    Just try!
    Regards, André

    S
    Forum|alt.badge.img+3
    • SarahLouise
    • New Participant
    • 4 replies
    • August 29, 2023

    @Sam_Gray I think you can solve this by adding another field with the name “Months”.

    The formula in that field would be:
    DATETIME_DIFF(TODAY(),{Date of Birth},‘months’)-Years*12

    So, you substract the sum of Years * 12 from the total amount of months that is calculated by the formula.

    Then, in the last field you add a formula to promt a message as soon as the value “11” is reached:
    IF(Months=11,“ :balloon: SEND A CARD”,BLANK())

    Just try!
    Regards, André


    Hi Andre_Zijlstra! 

    I'm hijacking this post 🙂 

    Please can i ask how you get the balloon icon?  As the formula didn't bring up the icon in the cell when i used it?

    Thank you!


    Terms & ConditionsAccessibility statement