Thread: Day Calculation Error
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Day Calculation Error
=(NOW()-F32) F32 contains(4/16/2007 7:15:00 AM)

Using your formula, I get 63 days for April 16th and 60 days for April 19th.

Rick

Reply With QuoteReply With Quote