IF Function not working for me

Bert Hoffbeck

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?

James Keuning

=IFERROR(IF(TODAY() > dob@row, MONTH(dob@row), ""), "")

Bert Hoffbeck

Thank you James!

James Keuning

=IFERROR(IF(TODAY() > dob@row, MONTH(dob@row), ""), "")

Bert Hoffbeck

Thank you James!