View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chris23892 via OfficeKB.com chris23892 via OfficeKB.com is offline
external usenet poster
 
Posts: 3
Default Arithmatic functions with date format...angry results

Can anyone tell me how to do the following:

I have a col. A and Col b with dates in the following format:

12/5/2008 12:00:00 AM and 11/19/2008 0:00


What I need to make a formula in the next col that will tell me how many days
apart these two dates are. Basically, just need to subtract the two dates
and display the number of day between the two dates..


Any thoughts on how to do this?
Thanks a bunch for all the help!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200901/1