Hello, I'm looking to count the number of times a value is under a certain period of time (in this case, two years). The tricky part for me is that I'm trying to count cells populated with a "#y #m #d" format from a DATEDIF formula.
Example below:
DATEDIF formula used in B2 and copied down:
Trying to get C2 to show "2" in this example, but I don't know how to do it with the "#y #m #d" format in column B. Any help would be appreciated.
Example below:
DATEDIF formula used in B2 and copied down:
Excel Formula:
=DATEDIF(A2,TODAY(),"y") & "y " & DATEDIF(A2,TODAY(),"ym")&"m " & DATEDIF(A2,TODAY(),"md") & "d"Trying to get C2 to show "2" in this example, but I don't know how to do it with the "#y #m #d" format in column B. Any help would be appreciated.
