Hi All,
I am trying to use a formula to perform a count how many times a date falls in between two date ranges. My problem is the date I am trying to use is exported to text format. To get the value of the text format, I want to use the =value() function.
But when I try to nest the =value() function in the countifs() function, i get the error that says I am not entering a proper formula. Is there a nuance I am missing here?
Thank you,
Vincent
Bookmarks