Date comparison, if greater than 30 then flag

Mily Oti

Hello,

I have two date columns that I would like to compare. The first column is named Requested and the second column is named [Sign off on]. In a third column formatted for symbols is where I've written the following formula,

=IF([SIGN OFF ON]@row + 45 > REQUESTED@row, 1)

I would like to get a flag if the [sign off on] column is 45 days greater than the requested column.

The problem is that it is flagging everything. Any suggestions?

Thanks,

Mily Oti

Mily Oti

Figured it out. The +45 needs to be with the Requested.

Mark Cronk

=IF([SIGN OFF ON]@row + 45 > REQUESTED@row, 1,0)

Mily Oti

Hi Mark,

Thanks for your reply. I added the 0 but it still flags every single row, even when there's only a day difference between the two.

If you can think of anything else, I would appreciate it.

Mily

Mily Oti

Figured it out. The +45 needs to be with the Requested.