# WEEKDAY Formula not working

Options

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!

## Best Answer

• ✭✭✭✭
Answer ✓
Options

Hi Meagan,

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

## Answers

• ✭✭✭✭
Answer ✓
Options

Hi Meagan,

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

• ✭✭✭✭✭✭
Options

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

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

• Options

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