Count between Dates
Hello I am trying to pull a few figures and am coming up empty on two situations.1.
 I would like to know the count of entries that have a date between 922021 & 9302021. The range is correct where the figure would pull from. Below is the formula.
 The second question I don't' know where to start. I want to know how many figures are in CIP&KYC 2021 range that do NOT equal #N/A. For instance is there are 200 entries, where 20 are #N/A and the other 180 have a date, the answer should be 180.
Best Answer

To test the solution I made a column with the same title as your cross sheet reference, but it should work the same. Here are the two formulas that will solve your questions.
1) =COUNTIFS([CIP &KYC 2021]:[CIP &KYC 2021], <=DATE(2021, 9, 30), [CIP &KYC 2021]:[CIP &KYC 2021], >=DATE(2021, 9, 2))
2) =COUNTIF([CIP &KYC 2021]:[CIP &KYC 2021], ISDATE(@cell))
I simplified the second solution to just look for the dates. Should be the same as searching for NAs if all you have are dates and NAs in the column.
Answers

To test the solution I made a column with the same title as your cross sheet reference, but it should work the same. Here are the two formulas that will solve your questions.
1) =COUNTIFS([CIP &KYC 2021]:[CIP &KYC 2021], <=DATE(2021, 9, 30), [CIP &KYC 2021]:[CIP &KYC 2021], >=DATE(2021, 9, 2))
2) =COUNTIF([CIP &KYC 2021]:[CIP &KYC 2021], ISDATE(@cell))
I simplified the second solution to just look for the dates. Should be the same as searching for NAs if all you have are dates and NAs in the column.

Thank you it worked!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!