Counting Dates less than 90 days from today
Hi there. I'm trying to write a formula that will tell me how may dates are less than 90 days from today. Here is what I thought should work, but it doesn't. I feel like I'm close. What am I missing? Here is the formula I have.
=COUNTIF([Start Date]:[Start Date])@row, TODAY-90)
Thank,
Tony Cooper
Answers
-
-
Hi Peggy,
Thank you. This is closer. Not it at least returns a value, but not the expected value. I know there are cells where the date is less than 90 days from today, however this returns a 0.
Thanks,
Tony
-
Good morning. I think I have a solution. See if this would work:
TODAY Helper column is an automation workflow (record a date) that runs daily.
90 Days Ago is a column formula: =[Today Helper]@row - 90
Start Date column is manually entered 🤷♀️
countif helper column is a column formula column: =COUNTIF([Start Date]@row, <[90 Days Ago]@row)
count (this could be a Sheet Summary field) contains formula: =COUNTIF([countif helper]:[countif helper], 1)
Peggy
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!