Months since certain date

[Mrmarc]

Hi all,

I have the following formula but it doesn't work,

Please Login or Register  to view this content.

What I want to do is calculate the months since 04/09/2017 but have it return an updated value as the months change. For instance since 04/09/2017 it has been 1 month.

Next month it will return 2 months etc.

Hope you can help as I am stumped.

Cheers,
Marc

[benishiryo]

hi Marc.
1. you cannot key in a date like this:
4/9/2017
that means 4 divided by 9 divided by 2017
use:
DATE(2017,9,4)
or refer it to a cell

2. input double quotes for the last argument, "m"

so:
=DATEDIF(DATE(2017,9,4), TODAY(), "m")
or if A1 contains 4-Sep-2017:
=DATEDIF(a1, TODAY(), "m")

[Mrmarc]

Ah i see where i was going wrong, wasn't aware it didn't reflect the date format like that. Thank you so much for your help!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.