Formula Question

MindyM

Hello - I need help getting a formula updated. I have the formula I currently have in the row pasted below. I want to add IFERROR into it so I don't have a bunch of cells that say #INVALID OPERATION. How do I add that into the formula I have below?

=[Session Date]@row - 25 + IF(WEEKDAY([Session Date]@row - 25) = 1, -2, IF(WEEKDAY([Session Date]@row - 25) = 7, -1))

Nic Larsen

Try: =IFERROR([Session Date]@row - 25 + IF(WEEKDAY([Session Date]@row - 25) = 1, -2, IF(WEEKDAY([Session Date]@row - 25) = 7, -1)), "")

Nic Larsen

Try: =IFERROR([Session Date]@row - 25 + IF(WEEKDAY([Session Date]@row - 25) = 1, -2, IF(WEEKDAY([Session Date]@row - 25) = 7, -1)), "")

MindyM

That worked! Thank you so much!