i have a complex if statement that i need help with. I have a contract that
tells to post a price from different days then from the day the price was
published. I need a formula that will give me Thursday's price for Monday
etc.

Day Price Publication Price
Mon Thurs (3days after mon)
Tue Fri (" ")
Wed Sat(" ")
Thurs Mon
Fri Wed
Sat/Sun Wed

I have the day (ddd) in one column - can i reference back to that somehow?

day(ddd) is in column c, the price is in column w, how can i tell column s
to give me thurs price for the monday cell, etc based on the price date
parameters? Is there even a way?

thx for all your help in advance!