WEEKDAY Formula not working

Meagan Harte

Hey all - I am trying to use the IF(WEEKDAY formula and it's not working. I'm so confused what I'm doing wrong, as I've used this same formula before with no issue. I'm wondering if it's my syntax, or perhaps my sheet? When using it, the error I get is "INVALID COLUMN FORMULA".

Here's the formula: =IF(WEEKDAY([Nomination Date]@row) = 1, [Nomination Date]@row + 3, IF(WEEKDAY([Nomination Date]@row) = 2, [Nomination Date]@row + 2, IF(WEEKDAY([Nomination Date]@row) = 3, [Nomination Date]@row + 1, IF(WEEKDAY([Nomination Date]@row) = 4, [Nomination Date]@row, IF(WEEKDAY([Nomination Date]@row) = 5, [Nomination Date]@row + 6, IF(WEEKDAY([Nomination Date]@row) = 6, [Nomination Date]@row + 5, IF(WEEKDAY([Nomination Date]@row) = 7, [Nomination Date]@row + 4, "")))))))

I basically want it to display Wednesday's date whenever the form is submitted in the chance that someone might submit the form incorrectly.

Thanks!

Ariana Arden

Hi Meagan,

Is Date the column type on both of your columns? I just tested your formula and it worked correctly for me. :)

Ariana Arden

Hi Meagan,

Is Date the column type on both of your columns? I just tested your formula and it worked correctly for me. :)

L_123

See above answer from @Ariana Arden , but this formula can also be simplified to

=[Nomination Date]@row - weekday([Nomination Date]@row) +4

Meagan Harte

THANK YOU BOTH! @Ariana Arden - that was the answer and I cannot believe I missed this!!! THANK YOU!