View Single Post
  #3   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

I have a status spreadsheet that counts how many days from a fixed date to
Now(), in one field the date is 16 April 2007, to Now() it is saying it is
3
days, when I move it to a different fixed date of 19 april it tells me 23
days, it should read 60 on 16 april and 57 on the 19 april. I have checked
the formating, and on some it counts properly.

Has anyone encountered this before if so please tell me how to fix it...


What formula are you using?

Rick