Make cell blank based off another cell

[cwicka]

Hi Everyone,

I am working on a spreadsheet and am working with 3 different columns. I have column Q which is a date and column S which is a date. I have a formula in column R (=Days360(Q2,S2). If there is no date in column Q column R is pulling a zero. I need a conditional format to say if a cell in column Q is blank then the corresponding cell in column R should be blank. Thank you all in advance for your help!

[AlKey]

Try it like this

=IF(OR(Q2="",S2=""),"",DAYS360(Q2,S2))

[cwicka]

Thank you very much for your help!

[AlKey]

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).