IF Formula help

Wanda Jackson

I'm working on another formula:

=IF([Deadline for Booth Info/Pmt]@row - TODAY() < 61, [Deadline for Booth Info/Pmt]@row - TODAY(), "")

This generates the number of days that are less than 61 days according to my date entered. I need to also add a formula to this same cell that will generate the number of days is more than 61 days according to my date entered.

Can you help with this?

Wanda J.

joelsmit94161

I am not entirely certain but I think you may need to do an IF(AND for that to work

Wanda Jackson

Thank you Joel. I changed the number in my formula and it worked without using IF(AND).