software

I've got a couple projects that require me to figure out how long we have
owned an asset. I have acquisition amp; disposal dates but I can't figure out
the formula to convert these into any form of days or months or years. Any
suggestions? My date columns are in the format 08/28/99. Thanks. Jason.


You can simply subtract the acquisition date from the disposal date. If
they're in A1 amp; B1 repectively

=B1-A1

format as general--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=505177I've tried that, all I get is another date. For example where I subtract
12/31/05 -11/30/03, I get 12/31/02.

These dates are imported from another program and appear date formatted, but
the subtraction doesn't work.

Thanks. Jason.

quot;daddylonglegsquot; wrote:

gt;
gt; You can simply subtract the acquisition date from the disposal date. If
gt; they're in A1 amp; B1 repectively
gt;
gt; =B1-A1
gt;
gt; format as general
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=505177
gt;
gt;


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

For the cell with your formula e.g. =B1-A1,use Format gt; Cells gt; Number
gt; 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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=505177