Mndsosa6741Copper ContributorJan 22, 2021IfsHello, I am trying to set up a spreadsheet where if the text value in column A is either of 2 customer names then the date in column M is 3 days after the date in column J and if it is not one of the...Show More
SergeiBaklanDiamond ContributorJan 22, 2021Mndsosa6741 In M1 it could be like =J1+3 + IF(OR(A1="customer1",A1="customer2"),6,0)
