Datedif function doesn't work when I use the cell with a date as start date reference

[Joy]

I'm trying to calculate the date between today and expiration date i
C43 (C43 is the predicted expiration date calculated base on othe
cells). My formula would be datedif(C43,today(),"m"). And it won'
work. What's the problem here

 

[Jason Morin]

2 possibilities:

1) The date is C43 is being interpreted as text. Check it
with =ISTEXT(C43)

2) The date in C43 is after today's date.

It would help it I knew what error you were seeing.

HTH
Jason
Atlanta, GA

 

[Gord Dibben]

Joy

DATEDIF Function needs earliest date first, then later date.

If expiration date is in the future......

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

For more on DATEDIF Function see Chip Pearson's site.

http://www.cpearson.com/excel/datedif.htm

Gord Dibben Excel MVP