Nested OR statement with Workday function

Rayme

I have two columns that populate dates, if one has a date in it the other one is empty. I'm trying to develop a formula that looks at both columns and returns the day of the week.

=IF(OR(WEEKDAY([Meeting Date]@row) = 2, WEEKDAY([Due Date]@row) = 2), "Monday", "") and I'm getting an #INVALIDDATATYPE error message. I've worked the formulas by themselves and they work but the minute I combine them it populates the error.

Paul Newcome

Try nesting the IF inside of the WEEKDAY function.

WEEKDAY(IF([Meeting Date]@row <> "", [Meeting Date]@row, [Due Date]@row))

Paul Newcome

Try nesting the IF inside of the WEEKDAY function.

WEEKDAY(IF([Meeting Date]@row <> "", [Meeting Date]@row, [Due Date]@row))

Rayme

Thanks! I knew I was overlooking something simple!

Paul Newcome

Happy to help. 👍️