"Live Date" is 4 weeks from "Submitted Date"

Betsy Herczeg-Konecny

Hi,

I'd like to set up conditional formatting to let me know if the "Live Date" column on my grid is indeed 4 weeks from the "Submitted Date" (Submitted is an auto-populated cell if that matters.)

I know I need a helper column, and I know how to do greater than, less than, equal to with an =IF statement, but how do I set the formula to account for the 4 weeks I want between "Live Date" and "Submitted"?

raltamirano

Hi!

Could you do =if([Live Date]@row=[Submitted Date]@row+28, "True","False)?

The 28 would account for the 4 weeks (4*7=28)!