Finding the Difference in Dates

[bflan0524]

hello
i have one column that list a date with a time and another column with a date. i need a formula to tell me the difference in months between the two columns. i am essentially trying to see how long the person owned the client at the time of the response date. so in this example below the answer would be 8 or i guess even argue 7 depending on how you wanted to look at it

Response Date	Owner Change Date
7/30/2019 19:28	12/20/2018

<tbody>
</tbody>

 

[tyija1995]

Hey,

Try DATEDIF:

=DATEDIF(B2,A2,"m")

Where B2 is the Owner Change Date (12/20/2018) & A2 is the Response Date (7/30/2019)

If this gives #NUM ! try swap the B2 & A2 around - the #NUM ! will occur if A2 < B2.

EDIT: =IFERROR(DATEDIF(B2,A2,"m"),DATEDIF(A2,B2,"m")) should do the trick in regards to what I wrote above.