LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve R
 
Posts: n/a
Default How do I count the number of days from 1 date to another?

I need to calculate the number of calander days from one date to another.
For example: if the start date is January 1, 2006 and the end date is January
2, 2006, I need the answer to be 2. When I subtract January 1 from January 2
I get an answer of 1. Please help.
 
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
formula for tracking number of elapsed days from a stard date spm1371 Excel Worksheet Functions 1 January 22nd 06 04:52 AM
need help with formula Bryan J Bloom Excel Discussion (Misc queries) 11 October 31st 05 10:52 PM
calculate the number of days from date received Donna Excel Worksheet Functions 7 July 18th 05 07:00 PM
Number of Days in a Date Range tesouthworthjr Excel Discussion (Misc queries) 6 July 14th 05 09:45 PM
calculating number of days (e.g., Mondays) between two dates girlfriend in school Excel Worksheet Functions 10 July 14th 05 07:21 PM


All times are GMT +1. The time now is 01:34 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"