Necroscope
Board Regular
- Joined
- Jul 7, 2004
- Messages
- 72
Hi.
I want to simply count the number of date entries in a range (B2:B60). There will either be a date in this field or it will be blank.
However, the issue that I can't solve is that some cells might actually have two dates in the one cell so I'd need the formula to count the two dates in that cell...
For example,
B2 - 12/04/18
B8 - 12/04/18 & 13/04/18
Is there a way to write the formula to produce a result of 3 in this case?
I want to simply count the number of date entries in a range (B2:B60). There will either be a date in this field or it will be blank.
However, the issue that I can't solve is that some cells might actually have two dates in the one cell so I'd need the formula to count the two dates in that cell...
For example,
B2 - 12/04/18
B8 - 12/04/18 & 13/04/18
Is there a way to write the formula to produce a result of 3 in this case?