I’m hunting for a formula that will display the upcoming birthday of an employee, client, vendor, etc. If their birthday is 6/25/1987 as input in the “Birthday” date column then I want the “Upcoming Birthday” formula/date column to read 6/25/2022 or whatever the upcoming birthday would be.
I know there has to be a way to do this with the formula function, I’m just not as versed in creating original formulas though. Can anyone help?
This should do it:
IF({Date},
FORMAT_DATE(
IF(DAYS(YEAR(TODAY()) & FORMAT_DATE({Date}, "-MM-DD"), TODAY()) < 0,
YEAR(TODAY()) & FORMAT_DATE({Date}, "-MM-DD"),
(YEAR(TODAY()) + 1) & FORMAT_DATE({Date}, "-MM-DD")),
"MMM D, Y"),
"")
You can change “MMM D, Y” in the second to last line to whatever date format you would like to see.
Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Keep your Integromat scenarios from timing out! - YouTube
Contact me directly here: Contact – The Monday Man
You, Sir. Are a gentleman and a scholar!
Works like a charm. Thanks!
hi guys, are you sure that the formula is working properly? Bc in my case it’s not really! in some cases I have the next date wrong (1 year too far). I want to create a board that notifies everybody when a birthday is coming (the day before to be precise). Can we work through that ?
thx a lot for your answers
Try this (I had typed “<” instead of “>” before):
FORMAT_DATE(
IF(DAYS(YEAR(TODAY()) & FORMAT_DATE({Date}, "-MM-DD"), TODAY()) > 0,
YEAR(TODAY()) & FORMAT_DATE({Date}, "-MM-DD"),
(YEAR(TODAY()) + 1) & FORMAT_DATE({Date}, "-MM-DD")),
"MMM D, Y"),
"")
hello, what did you add to the formula to show you also the age in the other column"age" ?
hello, what did you add to the formula to show you also the age in the other column"age" ?