If statement with date - Error on blank cells

[Amanda_Gronewol]

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.

[augmented · Accepted solution]

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

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

with

IF({Date}...