Cant get DATEDIF function to work

Question

=datedif(TODAY(09/18/2019),C3,"m" 

Looked at a bunch of questions similar to this one and none of the recommendations seem to work for me

Answer 1

Hi Kristine,

I agree with Joeu's suggestion, and you could try his formula or share more information as he mentioned. Since we don't know the content and cell format of C3, as well as any error message like #VALUE  ?

To add a point, it's not suggested to enter content in this bracket TODAY(), if you want to modify the date, you might select a cell then input the date into it the same way you choose C3. For reference, you could view this page: DATEDIF function

Please feel free to post back with a sample or a screenshot if the problem remains, and I would initiate a PM invitation for you, you could send me the sample or share the file via this link.

Best Regards,

Oliver

Answer 2

Is there a date in C3?  If so, is the date before, after or the same as "today"?

If on or after, try the following:

=DATEDIF(TODAY(), C3, "m")

If on or before, try the following:

=DATEDIF(C3, TODAY(), "m")

If that does not give reasonable results, the problem might be the value of C3.

First, confirm that =ISNUMBER(--C3) returns TRUE.  If not, we might need more information.

Answer 3

Hi Kristine,

Have you solved the problem? 

If the problem remains, you could share details with us for further troubleshooting.

Also, we will appreciate it if you share any experience here.

Have a nice day:)

Best Regards,

Oliver