tuckercp05
New Member
- Joined
- Nov 30, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
I created a separate worksheet to test this theory, because I cannot understand for the life of me what is going on with my Excel, or maybe I'm missing something and someone could point me in the right direction. I added 8 random dates, and to test the COUNTIF function, created a simple formula for counting the values if a greater than date. Somehow it's returning 6 when it is greater than all 8 values in the array. When changing the date entirely, a value of 8 is returned although I can clearly count the number should be 3.
Are my dates or operations incorrect?
Are my dates or operations incorrect?