Formula to check box if Date is 7 days ago

Paul Newcome

Grr... Ok. What about this one?

=IFERROR(IF(INDEX(Date:Date, Row@row - 1) < TODAY(-7), 1), "")

Andrea Westrich

@Paul Newcome I think this might work. No error in row 1 and I did some testing with dates and it looks good. I'll keep an eye on it for my automation; but I think this is it.

How can I thank you for all your work on this? I'm so grateful!!

Paul Newcome

I am happy to help. 👍️

And no need to thank me. All I ask is that you mark the most appropriate comment(s) as the "Accepted Answer" so that others in the Community searching for a similar solution can know that one may be found here.

ZoeChrys

Hi Paul,

Hope you are well.

I am trying to use this formula for a similar function in my sheet. The aim is to check the box when the date in the ETA column is within the next 90 days (and leave blank if there is no date).

But the formula is not working - Any ideas on how to adapt the formula?

Thank you in advance.

Zoe

Paul Newcome

@ZoeChrys Is the formula in the same sheet as the date?

ZoeChrys

@Paul Newcome yes formula is in the same sheet as the date

Paul Newcome

@ZoeChrys In that case you would need something more like this:

=IF(AND([ETA Column Name]@row >= TODAY(), [ETA Column Name]@row <= TODAY(90)), 1)

ZoeChrys

Thanks @Paul Newcome that works perfectly!!! Makes my life so much easier.

Paul Newcome

Happy to help. 👍️