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 9-2-2021 & 9-30-2021. 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.
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.