I have column A with dates, column B with letters like M (monthly), Q (quarterly), etc; column C is A (date) plus 1 month if column B is M; plus 3 if Q.
June 1, 2018. M. July 1, 2018
June 1, 2017. Q. September 1, 2018
Is there a way to write an if, then formula so I only have to update column A and it automatically figure C based in B?