Calculating if one date is 14 days greater than another date

Sharon Castiglia

Hello,

I need to calculate a flag if the construction end date (in a cell) is greater than 14 days from the construction start date (in a cell). If the result is greater than 14 days the row will be flagged. I don't even know how to start. Any help would be appreciated.

Mark Cronk

Hi @Sharon Castiglia ,

Create your flag column. In it place a column formula:

=IF([construction end date]@row-[construction start date]@row>14, 1, 0)

Modify the column names to match your sheet.

Work?

Mark

Mark Cronk

Hi @Sharon Castiglia ,

Create your flag column. In it place a column formula:

=IF([construction end date]@row-[construction start date]@row>14, 1, 0)

Modify the column names to match your sheet.

Work?

Mark

Sharon Castiglia

Wow it was that simple. Thought I needed way more than that. Thank you