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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!