DateIF and countif? Excel formula

Asked Jul 13 '22 at 16:57

Active Jul 13 '22 at 16:57

Viewed 52 times

I have a list of IDs that have multiple dates and I am trying to count the months for each specific eeid to calculate a timeframe how long someone is on medication.

So far, I did a countif(A:A,A) showing how many times the eeid shows up but now I am figuring out how to add in the months.

Example:

EEID DATE        count of months? 
1234 1/2/20               5
1234 5/2/20               5
1234 6/2/20               5
2222 5/6/21               3
2222 8/6/21               3
9876 3/2/22               0
5555 12/2/21              6
5555 1/2/22               6
5555 3/2/22               6
5555 5/2/22               6

Thank you!

asked Jul 13 '22 at 16:57

Jmar

what version do you have? – Scott Craner Jul 13 '22 at 16:58
one hint: you are not trying to count the months but figure the number of months between the max date of that eeid and the minimum date of that eeid. – Scott Craner Jul 13 '22 at 16:59
=MAX(IF(G:G=G2,J:J))-MIN(IF(G:G=G2,J:J)) - G would be the eeid and J would be either the max or min date; now what i have is a date.... i think – Jmar Jul 13 '22 at 17:17
`=INT((MAX(IF(G:G=G2,J:J))-MIN(IF(G:G=G2,J:J)))/30)` – Scott Craner Jul 13 '22 at 17:21

DateIF and countif? Excel formula

0 Answers0