View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete Pete is offline
external usenet poster
 
Posts: 193
Default Subtracting dates in Excel 2003

Cool. So why doesn't Office Help mention this tidbit?
--
Thanks!

Pete.


"Steve Yandl" wrote:

Pete,

Select the cell with your formula. Click the 'Format' drop down and select
'Cells' and you should have the 'Number' tab selected. Change the format to
a number with no places to the right of the decimal and OK your way out.

Steve


"Pete" wrote in message
...
I'm trying to subtract dates in E2003, but I'm getting a date as the
output:
1/17/2007-11/3/2005 gives me not a number of days but 3/15/1901.

Any suggestions?
--
Thanks!

Pete.