Need help with dates

[jjkkss]

I have a table that is tracking multiple savings goals, when they are due, and how much I have to save to reach my goal. I want to add a fourth column that tells me how many months I have left before the due date, so I can include a fifth column that will calculate how much I have to save per month to reach my goal by the due date.

This is my data:

GOAL	DUE	$ LEFT	MO LEFT	SAVE PER MO
500	FEB 2021	350	FORMULA	=C2/D2
200	DEC 2020	175	FORMULA	=C3/D3
300	APR 2021	200	FORMULA	=C4/D4
300	APR 2021	200	FORMULA	=C4/D4
300	APR 2021	200	FORMULA	=C4/D4
300	APR 2021	200	FORMULA	=C4/D4

TODAY

10/02/20

What formula can I put into Column D that will calculate time in months from today until the due date in column B?

[6StringJazzer]

What is the underlying data in column B? You are showing just a month and year. Is this text, or is it a formatted date?

In general any time you are dealing with dates in Excel, they should be represented as dates, not text, otherwise it is very difficult to use them in formulas.

[Croweater]

In D2 try...

=DATEDIF(TODAY(),B2,"M") and drag down

Don't forget you'll need to test for divide by 0 in the next column.

[jjkkss]

The date is fomatted data, just in the format of MMM YYYY. The data itself if the first of the visable month.

[jjkkss]

In D2 try...

=DATEDIF(TODAY(),B2,"M") and drag down

Don't forget you'll need to test for divide by 0 in the next column.

Not working. I basically will need a formula that will subtract the date due from today's date and convert it to number of months. It this possible?

[6StringJazzer]

Not working.

This is exactly what I would have suggested. What you do mean "not working"? What are you expecting and what is happening instead?

[jjkkss]

This is exactly what I would have suggested. What you do mean "not working"? What are you expecting and what is happening instead?

I input the DATEDIF formula and it returned a #NUM error, but I realized that I had 2020 for the due date year instead of 2021. Which meant the due date was earlier than today. Fixed the due date year and now it's working. Thanks!!