Date Formula Q

mattimer

Hi All.

Pretty easy one for you all, I think.

I'm trying to create a formula where in if the date in the "Date" column is < 12/31/2023, value of X is returned if true, and Y is returned if false (i.e, after the new year). Keep getting #UNPARSEABLE error. This is one that is easy in Excel, but can't get to work in SS.

=IF(Date@row<12/31/2023,x,[y])

John_Foster

Hi @mattimer,

Try this formula, it replaces your date of 12/31/2023 with a date creator function.

=IF(Date@row<DATE(2023,12,31),x,[y])

The date creator takes three arguments which are Year, Month then Day.

Hope this helps!

John