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