LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
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...
Thank you Steve...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculation Error? Wei Ming from singapore Excel Discussion (Misc queries) 3 January 3rd 07 12:39 PM
Excel calculation error? Mike Excel Discussion (Misc queries) 1 June 8th 06 04:36 PM
Calculation Error? Randy Sp Excel Discussion (Misc queries) 1 March 17th 06 08:27 PM
Re-Calculation error 5 Star Excel Discussion (Misc queries) 2 June 16th 05 05:05 PM
calculation error happyearth Excel Worksheet Functions 2 June 16th 05 05:59 AM


All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"