If/Then date question

Ryon

Hi All,

I'm trying to use the formula below to populate a cell with "late" if the Date Opened +30 days is greater than the Original Due Date. Is this possible? I'm very new to the formula side of SS so any help would be appreciated! Thanks!

=IF([Date Opened]1 + 30, >[Original Due Date]@row, "late", "")

Shimanta Roy

Hi Ryon,

Your formula was almost perfect. A syntax error was there. Try using the following formula:

=IF([Date Opened]@row + 30 > [Original Due Date]@row, "Late", "")

Shimanta Roy

Hi Ryon,

Your formula was almost perfect. A syntax error was there. Try using the following formula:

=IF([Date Opened]@row + 30 > [Original Due Date]@row, "Late", "")

Ryon

Awesome, that solved it! I appreciate the help!