PatRichard
New Member
- Joined
- Dec 29, 2018
- Messages
- 16
- Office Version
- 365
- Platform
- Windows
Greetings - I didn't see this in a search, but maybe I'm not searching right. I have a table with a column of dates. Some of the dates are mm/dd/yyyy, and some are just mm/yyyy. I'm trying to count the number of cells in a column in which the year is a specific value. But I'm just coming up with 0. I'm using:
but also tried replacing the year with a cell reference (I'm building a table that shows quantities by year).
What am I missing here?
Excel Formula:
=COUNTIF((MyInventory[Born On]),1985)
What am I missing here?