M
Melissa
What is the formula to display the number of months between 2 dates?
Thanks,
Melissa
Thanks,
Melissa
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefi
Have a look at this site:
http://www.cpearson.com/excel/datedif.aspx
--
Regards!
Stefi
„Melissa†ezt Ãrta:
http://www.cpearson.com/excel/datedif.aspx
--
Regards!
Stefi
„Melissa†ezt Ãrta:
J
Jarek Kujawa
=DATEDIF(A1,B1,"m")
M
Melissa
I forgot to mention I am using Excel 2000.
I used this formula: dateif(A3,A2,"m") and got a #NAME? result.
My dates are all in column A (in ascending order).
I used this formula: dateif(A3,A2,"m") and got a #NAME? result.
My dates are all in column A (in ascending order).
D
David Biddulph
There is no function DATEIF, so that is why you got the #NAME? result.
Try DATEDIF.
Try DATEDIF.
M
Melissa
Thanks!
David Biddulph said:There is no function DATEIF, so that is why you got the #NAME? result.
Try DATEDIF.
--
David Biddulph
.