IF Function not working for me

I'm referencing a Birth Date in a sheet and want to use the IF Function along with the Month Function to isolate the month of a person's birthday date.
The DOB column is in DATE Format (i.e. 12/05/75). Some of the rows do not have any data populated in them, and I'm trying to return a blank (i.e. "") for those conditions.
The formula I'm trying to use in another column its Text/Number.
Here's my formula
=IF(TODAY() > DOB@row, MONTH(DOB@row), "")
If will properly calculate if the DOB column has a date, but returns #INVALID DATA TYPE, if that DOB Column is not populated.
Any ideas on how to work around this?
Best Answers
-
=IFERROR(IF(TODAY() > dob@row, MONTH(dob@row), ""), "")
-
Thank you James!
Answers
-
=IFERROR(IF(TODAY() > dob@row, MONTH(dob@row), ""), "")
-
Thank you James!
Help Article Resources
Categories
Check out the Formula Handbook template!