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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Response Date[/TD]
[TD]Owner Change Date[/TD]
[/TR]
[TR]
[TD]7/30/2019 19:28[/TD]
[TD]12/20/2018[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.