=if(h9=13500100,eomonth($o$8,-2)

[srizki]

I have, =IF(G9<>"",EOMONTH($O$8,-1),"") - In column, “M”, I want to add in this formula that if corresponding cell in column, “H”, houses, “13500100”, it should go back to two months.
For example, if I type 03/15/2018 in “O8” it should get 01/31/2018, and not 02/28/2018 as it is now.

Thankse

 

[shg]

=IF(G9 = "", "", EOMONTH($O$8, if(H9 = "13500100", -2, -1)))

 

[srizki]

Thank you but that does not work.

 

[Delfinus25]

Can't you just use an embedded if statement?

=IF(G9<>"",(IF(H9=13500100,(EOMONTH($O$8,-2)),(EOMONTH($O$8,-1)))),"")

 

[srizki]

Thank you, yes this is working.

 

[srizki]

shg,

I tried your formula again and it worked, I removed quotes from "13500100", as this is number, not text.

Thanks again,

Best regards,