Net Days Since X
Hello! I have a form input multiple times per day to the top of the sheet with a YES/NO column and a date column. I am trying to count the number of days since YES so that if TODAY is YES, the number would be 0. Any help would be greatly appreciated!
Example:
12/31/20 - Yes, 1/1/21 - No, 1/2/21 - No, 1/2/21 - No, - No, 1/3/21 - No - should calculate 3.
1/1/21 - No, 1/2/21 - Yes, 1/2/21 - Yes, - No, 1/3/21 - No - should calculate 1.
Answers
-
Hi @LoganDavison
Hope you are fine, please check the following formula.
=COUNTIFS([Yes / NO]:[Yes / NO], "Yes")
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Bassam.M Khalil ,
Thanks for your suggestion! This does not resolve adding in the dates. I need to count days, instead of straight quantity of YES.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!