Calculate Date based on Criteria in Two Cells
I need to write a formula to check a cell for a size (Small, Medium, or Large) and calculate a start date from a go-live date in another cell. If the size is small, it's 14 days earlier, if it is medium, it is 21 days earlier and if large 28 days earlier.
I've go this as my starting point: =IF([Size]@row, Small,[Go-Live]-14) but so far it's unparseable.
Thanks for the help