I have an age formula that returns an "error" if no birthday is available. How do I remove the "error"


#1

I have an age formula that returns an “error” if no birthday is available. How do I remove the “error”


#2

Hi Greg, were you able to fix this? I’m having the same issue


#3

You can use a conditional statement to return a blank cell if the “Birthday” field is empty:

IF(Birthday, DATETIME_DIFF(NOW(),Birthday,’years’),BLANK())

That should do it.