Formula to check box if Date is 7 days ago
Answers
-
Grr... Ok. What about this one?
=IFERROR(IF(INDEX(Date:Date, Row@row - 1) < TODAY(-7), 1), "")
-
@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!!
-
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.
-
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
-
@ZoeChrys Is the formula in the same sheet as the date?
-
@Paul Newcome yes formula is in the same sheet as the date
-
@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)
-
Thanks @Paul Newcome that works perfectly!!! Makes my life so much easier.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!