|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 2nd, 2006, 08:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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. 
|
|
#2
February 2nd, 2006, 08:54 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of days from 1 date to another?
Just add 1.
=B1-A1+1 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Steve R" Steve wrote in message ... 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.
|
|
#3
February 2nd, 2006, 08:55 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of days from 1 date to another?
Well if that is your definition of difference, just add 1 to the difference.
So if two dates are equal the difference is 1? -- Kind regards, Niek Otten "Steve R" Steve wrote in message ... 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.
|
|
#4
February 2nd, 2006, 08:58 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count the number of days from 1 date to another?
Your right on track. It is as simple as it appears, but you want something
different than your asking for. 1/2/2006 and 1/1/2006 are only one day different, so the answer is 1. Just add 1 to the end of your formula to, in effect, calculate the days between 12/31/2005 and 1/2/2006. i.e., not =a2-b2 instead =A2-(B2-1) that should do it. "Steve R" wrote: 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 | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
| Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
| How to calculate days:Hours:Minutes: | Kurewe | Worksheet Functions | 46 | January 17th, 2005 11:11 AM |
| Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
| Adding a specified number of business days to a start date | Frank Kabel | Worksheet Functions | 2 | February 24th, 2004 04:46 PM |
Linear Mode
