Shoulders,

Set a formula to subtract the dates as if they were numbers =A2-A1 for
instance. The Date Time setup in your control panel will have to be set
to the US format so the computer understands that there are not 13
months in the year. Once you're done that the format of the cell that
contains the answer will have to be formatted to number (not days else
it won't count over 30 days)

Regards


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=475809