This one works in Excel:=IF(AND(A1>DATE(2017,1,1),A1<DATE(2017,6,30)),1,2)

Quote from: solon on October 13, 2017, 10:29:41 AMThis one works in Excel:=IF(AND(A1>DATE(2017,1,1),A1<DATE(2017,6,30)),1,2)you could also simplify this further to =IF(MONTH(A1)<7,2,1)This way you will not have to update it every year. Edit: If you wanted to exclude column B then your formula would be =IF(MONTH(A1)<7,2,1)*C1

Quote from: Proud Foot on October 13, 2017, 12:53:58 PMQuote from: solon on October 13, 2017, 10:29:41 AMThis one works in Excel:=IF(AND(A1>DATE(2017,1,1),A1<DATE(2017,6,30)),1,2)you could also simplify this further to =IF(MONTH(A1)<7,2,1)This way you will not have to update it every year. Edit: If you wanted to exclude column B then your formula would be =IF(MONTH(A1)<7,2,1)*C1Yeah, that's much more elegant. Plus, you got the 2 and the 1 in the right order!

Quote from: solon on October 13, 2017, 01:02:22 PMQuote from: Proud Foot on October 13, 2017, 12:53:58 PMQuote from: solon on October 13, 2017, 10:29:41 AMThis one works in Excel:=IF(AND(A1>DATE(2017,1,1),A1<DATE(2017,6,30)),1,2)you could also simplify this further to =IF(MONTH(A1)<7,2,1)This way you will not have to update it every year. Edit: If you wanted to exclude column B then your formula would be =IF(MONTH(A1)<7,2,1)*C1Yeah, that's much more elegant. Plus, you got the 2 and the 1 in the right order!This is awesome!!!! How do I tell it month<6 AND day < 10???

If the harvest falls between Jan and June of the year, then I want to double the amount I plant (because that's when our CSA is running).

This is awesome!!!! How do I tell it month<6 AND day < 10???