|I am trying to write a formula where if there is a "Y" in a certain cell, then my formula returns a certain EDATE formula but if the cell is blank then I get a different EDATE formula. Can someone please help: Here are my parameters:|
Cell E39 = base date
Cell p39 = text cell ("Y" or blank)
Formula: =IF(P39="Y",(EDATE(E39,9)+15), (EDATE(E39,7)))
I get the result for (EDATE(E39,9)+15 no matter what is in P39.