Formula stops working when changing name of column

SSParks

Greetings-

I have the following formula that tells me what day of week a specific date is if the date column is called "Date". If I try and change the formula to reference a column called "Date of Program" the formula doesnt work anymore. Why is this? How can I make it work with a date column called Date of Program instead of just Date? I updated the formula to say (Date of Program@row) but that doesnt do it. Thanks for any info. MD

WORKS

=IFERROR(IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday"))))))), "")

Doesnt WORK

=IFERROR(

IF(WEEKDAY(Date of Program@row) = 1, "Sunday", 

IF(WEEKDAY(Date of Program@row) = 2, "Monday", 

IF(WEEKDAY(Date of Program@row) = 3, "Tuesday", 

IF(WEEKDAY(Date of Program@row) = 4, "Wednesday", 

IF(WEEKDAY(Date of Program@row) = 5, "Thursday", 

IF(WEEKDAY(Date of Program@row) = 6, "Friday", 

IF(WEEKDAY(Date of Program@row) = 7, "Saturday"))))))), "")

Colleen Patterson

Since there is a blank space in the title, you need to add brackets around the column name [Date of Program].

If you update where you have that name to the bracketed name, it should resolve.

Colleen Patterson

Since there is a blank space in the title, you need to add brackets around the column name [Date of Program].

If you update where you have that name to the bracketed name, it should resolve.

SSParks

That worked! Thank you for the help!