Pammy,

=DATEDIF(C4,B4,"m")

In general,

=DATEDIF(older date, newer date,"m")

See

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

--
HTH,
Bernie
MS Excel MVP


"Pammy" wrote in message
...
If I have 2 date columns how do I create a formula to subtrack? example:
(b4) November 30, 2007 and (c4) November 6, 1986. My formula is:
=month(b4)-month(c4) in column D, but I get 0 and I have formatted the
column to numbers.
I also did =month(c4)-month(b4). Is there another way to this to get the
correct #?