If statement with date - Error on blank cells

I am trying to check to see if the Date column is empty, then if not, display the date’s weekday in the Day of Week column.

Here’s my formula in the Day of Week column:

IF({Date}!=BLANK(),DATETIME_FORMAT({Date},'dddd'),"")

I do not understand why I am getting errors for all the blanks. I’ve tried several different versions of the formula above. Any help appreciated.

Hi Amanda. Even when your date field looks empty, it is not BLANK(). Replace…

IF({Date}!=BLANK()...

with

IF({Date}...

2 Likes

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