Skip to main content

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

@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,“ 🎈 SEND A CARD”,BLANK())


Just try!

Regards, André

@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,“ 🎈 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!

Reply


Terms & Conditions