Count if Column has a date
I'm trying to build a ship status sheet and use the sheet summary to give me a count if a certain column has a date.
something like: =COUNTIF([Estimated Ship Date]12:[Estimated Ship Date]22, (ISDATE(, "1", "0"))
but all i can seem to get is UNPARSABLE
Best Answer
-
=COUNTIFS([Estimated Ship Date]12:[Estimated Ship Date]22, ISDATE(@cell))
I believe the above gives you your count for that specific date range. As written, you will have to manually update if the range changes. Inserting other criteria in your COUNTIFS statement could provide a means of keeping your range dynamic, thus eliminating the need for manual intervention. If there is additional criteria and you need help with the syntax, give the community another shout.
cheers,
Kelly
Answers
-
=COUNTIFS([Estimated Ship Date]12:[Estimated Ship Date]22, ISDATE(@cell))
I believe the above gives you your count for that specific date range. As written, you will have to manually update if the range changes. Inserting other criteria in your COUNTIFS statement could provide a means of keeping your range dynamic, thus eliminating the need for manual intervention. If there is additional criteria and you need help with the syntax, give the community another shout.
cheers,
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!