Date of birth not emptpty, Execute Formula, If Populated, Show Text Output

[costavia]

Hello dear Community,
Does anyone implemented the following formula, mine does not populate text if column is empty.

IF(MONTH(TODAY())>MONTH({Date of birth});YEAR(TODAY())-YEAR({Date of birth});IF(MONTH(TODAY())=MONTH({Date of birth});IF(DAY(TODAY())>=DAY({Date of birth});YEAR(TODAY())-YEAR({Date of birth});YEAR(TODAY())-YEAR({Date of birth})-1);YEAR(TODAY())-YEAR({Date of birth})-1))

“No date of birth entered”)

@ JCorrell?

[psperry (Accidental Selfie)]

I thought I had the answer. Pretty sure it’s about syntax but I can’t figure it out. I defer the the Maha- @JCorrell .

[JCorrell (Jim - The Monday Man)]

@costavia, @psperry

It’s not as fancy; but this is how I would probably do it:

IF(AND({Date}, DAYS(TODAY(), {Date})>0),
   INT(YEARFRAC(FORMAT_DATE({Date}), TODAY())),
   "Birthdate Error"
)

---

Jim - The Monday Man (YouTube Channel)
What is Make & How can it help you?
Schedule a 1-on-1 Tutorial Session

[costavia]

YES YES YES - thank you!