Is there a formula to calculate 60 days from " date column 2" only if "date column 1" is blank?

Aishwarya Lakshman

Matt Johnson

Hi @Aishwarya Lakshman

If I understand the situation correctly, below should be the formula. If you want to add days to the Trustee Sale Date, you could add that to the end of the formula.

Matt Johnson

Hi @Aishwarya Lakshman

Maybe try this:

=IF([Column1]@row = "", [Column2]@row + 60, "")

It means: If Column1 is blank, add 60 days to Column2 and show that date, otherwise show blank.

I hope that helps.

Matt

Aishwarya Lakshman

@Matt Johnson Thank you so much for your reply, the formula worked. But what we are trying to do with this sheet is to set up automations to alert people when the follow up date is reached. This is were we would need a formula that would recognize if blank if ‘Trustee Sale Date’ column, then 60 day follow up from the NOD column AND if there is a date in the Trustee Sale date column, then only read that column + days to = the follow up date.

Is that possible?

Matt Johnson

Hi @Aishwarya Lakshman

If I understand the situation correctly, below should be the formula. If you want to add days to the Trustee Sale Date, you could add that to the end of the formula.

Aishwarya Lakshman

That's what I was looking for. It works now, Thank you so much for helping me with it @Matt Johnson