First time poster here
I'm trying to count the frequency of occurrences based on specific date ranges.
Here is my current formula
=COUNTIFS(MRN,$B2,VisitDates,"<=&6/14/2018",VisitDates,">=&6/14/2018-30")
It works just fine with the TODAY function but I don't want it to change every time I open the file so I tried to ctrl+; to make it a fixed date and macro friendly but the results come back as "0" when I do that. Unfortunately I don't know VBA well at all, although I'm trying to teach myself.
Any suggestions?
I'm trying to count the frequency of occurrences based on specific date ranges.
Here is my current formula
=COUNTIFS(MRN,$B2,VisitDates,"<=&6/14/2018",VisitDates,">=&6/14/2018-30")
It works just fine with the TODAY function but I don't want it to change every time I open the file so I tried to ctrl+; to make it a fixed date and macro friendly but the results come back as "0" when I do that. Unfortunately I don't know VBA well at all, although I'm trying to teach myself.
Any suggestions?
