Hello. I need to calculate the difference of months only. Unfortunately, the data we have been provided is not in the same format.
We have column G containing the dates formatted:
3/10/2006
and we have column P containing only the number of months, i.e.:
9
I tried =MONTH(G2)-MONTH(P2), but if the month in column G is greater than the month in column P, I need to count FROM G to P. For example, assume:
G = 11/31/1991 and P = 09, the difference I need to calculate is FROM 11 to 09, which would be 10 months. The formula above gives me -2 months. I need it to calculate the difference in months going forward if that makes any sense. I also need the result to be in NUMBER format (which the MONTH formula gives). We will use that result to multiply with a rate.
I know our formatting is weird, but this is the data we have to work with and it's a couple of thousand rows. Thank you.
We have column G containing the dates formatted:
3/10/2006
and we have column P containing only the number of months, i.e.:
9
I tried =MONTH(G2)-MONTH(P2), but if the month in column G is greater than the month in column P, I need to count FROM G to P. For example, assume:
G = 11/31/1991 and P = 09, the difference I need to calculate is FROM 11 to 09, which would be 10 months. The formula above gives me -2 months. I need it to calculate the difference in months going forward if that makes any sense. I also need the result to be in NUMBER format (which the MONTH formula gives). We will use that result to multiply with a rate.
I know our formatting is weird, but this is the data we have to work with and it's a couple of thousand rows. Thank you.