subtract dates to month

Have a look at the DateDif function. Information can be
found at:

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

Damon Longworth

2006 West Coast Excel / Access User Conference
October 25-27th, 2006
Marina del Rey Hotel
Marina del Rey, California USA
http://exce
luserconference.com/WCEUC.html


-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-GPEACH.EASE.LSOFT.COM] On
Behalf Of Sean Gallivan
Sent: Monday, September 25, 2006 6:28 AM
To: EXCEL-GPEACH.EASE.LSOFT.COM
Subject: subtract dates to month


Hi all,
	I am trying to create a formula that will calculate to the
nearest 
month the difference between two dates: In UK this is
03/04/2006 - 
25/09/2006 would equal 6.
	Any ideas would be gratefully received.

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info and
archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G