Is there a way to count the number of dates in a cell?
I want to include a column that indicates the number of times the due date has been extended, but not sure what would be the best way to do this. The "Fulfillment Due Date History" Column on my sheet has a cross-sheet formula that lists the various due dates if they have changed. Could a formula be set up to count the number of dates in the the history column which is basically the number of extensions?
For example, the first two lines below are requests that have not been extended since the history column is blank. The third line shows a request that has been extended 3 times since there are 3 different dates referenced in the history column. I'd like the number of extensions to be referenced in the "Number of Extensions" column.
Thoughts on a better way to accomplish this are also welcome.
Help Article Resources
Check out the Formula Handbook template!