Are you trying to subract the later date from the earler one?. If A2 is
your start date (say 15/12/05) and the end date in A3 is later than
this one (say 30/01/06), then the formula to calculate the number of
days between these is a3-a2. You will need to change the format of the
answer cell (A4) to General rather than Date otherwise you will get an
answer of 15/02/1900 00:00

Cheers
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=400387