Morning Fiona
Set up the formula so (eg) =B1-A1 and format the cell using
FORMAT/CELLS/NUMBER select CUSTOM and enter in the TYPE box this: mm
This gives you whole months between dates and might not be as accurate
as you might need
Jon
--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile:
http://www.excelforum.com/member.php...o&userid=25803
View this thread:
http://www.excelforum.com/showthread...hreadid=471660