Formula to check a box when date entered + 2 days

Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row.

For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete.

This is the formula that I have been trying without success...

=IF([Finish Step]3 >= TODAY(+2), 1, 0)

Thank you!

Find more posts tagged with

Manufacturing

Construction

Formulas

Real Estate

Services

IT & Operations

Project Management

Comments

Mike Wilday

Try removing the plus sign.

dplunkett79331

That didn't work. Also tried DAY vs TODAY and neither worked. Seems like there should be some way to do this.

Thanks!

Paul Newcome

Try this...

=IF(TODAY() >= [Finish Step]@row+ 2, 1, 0)

dplunkett79331

That does result in a checked box. However, it checks boxes even if there is no date in the Finish Step column...

Paul Newcome

That's because TODAY will always be greater than a blank cell. Adding this in should fix that...

=IF(AND(ISDATE([Finish Step]@row), TODAY() >= [Finish Step]@row+ 2), 1, 0)

Mike Wilday

Thanks for jumping in Paul.

Paul Newcome

Sure thing!

dplunkett79331

THANK YOU! This worked great!

Paul Newcome

Happy to help!

Peggy Parchert

@Paul Newcome - Is it possible to use a formula if you wanted to check a box if the date was equal to or greater than 10/22/2019? I can't seem to modify the above formula to make it work...

Andrée Starå

Hi @Peggy P,

Try something like this.

=IF(ISDATE(Date@row); IF(Date@row <= DATE(2019; 10; 22); 1))

The same version but with the below changes for your and others convenience.

=IF(ISDATE(Date@row), IF(Date@row <= DATE(2019, 10, 22), 1))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

@Peggy P @Andrée Starå

You're going to want to flip the symbol from Less than to Greater than. Also since we are looking for Greater Than, we don't need to include the ISDATE portion either.

=IF(Date@row >= DATE(2019, 10, 22), 1)

Andrée Starå

@Paul Newcome Good catch! 👍️

Paul Newcome

@Andrée Starå Thanks. I do that to myself pretty regularly. Haha

Peggy Parchert

@Andrée Starå @Paul Newcome - That worked! Thank you very much!

Sign in to join the conversation!

Quick Links

Trending discussions

How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
count if value is between a date range (reference between 2 sheets)
Hi team i have 2 sheets for material inventory. the first is to record witch equipment is ship out for repair and the other is the total of equipment available. the first is set as follow: equipment type, date out, date return, quantity (negative number) the other one is as follow: each row is for a single date with the…