Excel formula to calculate number of months over due

[kumar0318]

Hello,

I'm trying to calculate the number of months past due from a given date.

For example: If my date is given as 06/25/2020

I would like to see in the new column how many months this is overdue from 06/26/2020 to the previous month (Feb 2022).

Thank you for your help in this matter.

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	A	B
1	Date	Months pass as of Last month
2	6/25/2020	20
Sheet1067

Cell Formulas
Range	Formula
B2	B2	=DATEDIF(A2,TODAY(),"m")-1

 

[kumar0318]

Thank you, this works!

 

[jtakw]

You're welcome.

 

[kumar0318]

I just realized that I didn't think about the status if there is a future date. How do you build the above formula to include the status "on track" if there is any future date?

 

[jtakw]

Not sure if I understand fully, may be this:

Book3.xlsx
	A	B
1	Date	Months pass as of Last month
2	6/25/2020	20
3	3/31/2022	on track
Sheet1063

Cell Formulas
Range	Formula
B2:B3	B2	=IF(EDATE(A2,1)>TODAY(),"on track",DATEDIF(A2,TODAY(),"m")-1)

 

[kumar0318]

Thank you!

 

[jtakw]

You're welcome.