How do I create formula to calc difference in dates?

I have a 'hire date' & a 'term date'. I need to calcuate the difference in
months & don't want to do the calculations manually. EX. 7/1/06 1/1/06 = 6
months

dlcroswell,

If 7/1/06 is in cell a1, and 1/1/06 is in cell b2 then
in cell c1*
=MONTH(A1)-MONTH(B1)

*note, you may have to format cells to general or number

Hope this helps

---Bigpig---

"dlcroswell" wrote:

> I have a 'hire date' & a 'term date'. I need to calcuate the difference in
> months & don't want to do the calculations manually. EX. 7/1/06 1/1/06 = 6
> months