IF formula for dates in the past and future

SmartsheetRookie

Hi,

I need a cell to do the following:

If Cell B is dated past Cell A date, leave Cell C blank. (for example, Cell A is dated 1/1/23. Cell B is dated 1/1/24. I need Cell C to be blank)

However, I already have the following formula in Cell C:

=[Cell A]$51 + 60

What do I need to add to the current formula to do the above?

Thank you!

Jeff Reisman

@SmartsheetRookie

You can have another formula as a condition of an IF formula! Put this in Cell C:

=IF([Cell B] > [Cell A], "", ([Cell A]$51 + 60))

English: If the Cell B date is after the Cell A date, leave Cell C blank, otherwise, execute this formula ([Cell A]$51 + 60).