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

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?

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 .

@costavia, @psperry

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

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

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

1 Like

YES YES YES - thank you!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.