It's all in the formatting.....

For the cell with your formula e.g. =B1-A1,use Format Cells Number
General and you should see a result of 762

Because you are subtracting dates excel assumes, wrongly, that you want
the result in a date format - because excel's dates start at 1st January
1900 if you count 762 days from that date you get 31st January 1902 so
your result showed as 01/31/02


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=505177