# Thread: Count Days (including start date) (Excel 2000)

1. ## Re: Count Days (including start date) (Excel 2000)

Subtract the earlier day from the later date and add 1.

Days = (Date2 - Date1) + 1

Andrew C

2. ## Re: Count Days (including start date) (Excel 2000)

The only "fancy" suitable function I can think of is NETWORKDAYS(), which is availbale if you have the Analysis ToolPak add-in installed and active. However it is a bit specialist as it does not count weekend dates, or any optional holday dates that may be passed to it. Check it out in Help.

Andrew C

3. ## Re: Count Days (including start date) (Excel 2000)

Oh well, if you want to get fancy, use the DateDif function (Excel 2000 is the only version in which DateDif is documented in the online help)

4. ## Re: Count Days (including start date) (Excel 2000)

Hans,

I think that produces the same result as Date2 - Date1, and to have both dates inclusive needs to have +1 included.

Andrew

5. ## Re: Count Days (including start date) (Excel 2000)

Yes, of course. My reply was facetious - I found it slightly strange to want a "fancy" function to calculate (Date2 - Date1) + 1. Please accept my apologies.

6. ## Re: Count Days (including start date) (Excel 2000)

Apparently, less is more. Just thought I might be missing something. That being said, being a new user to Woody's Lounge, I didn't appreciate the facetious replies and am thus inclined to use this forum for searching only vs. posting.

7. ## Re: Count Days (including start date) (Excel 2000)

I am very sorry if I offended you. I apologize and I hope that one negative experience will not deter you from using the collective knowledge of the Lounge to your best advantage. The general atmosphere here is friendly and helpful.

8. ## Re: Count Days (including start date) (Excel 2000)

Thanks! Already using that, but thought there might be a function.

9. ## Count Days (including start date) (Excel 2000)

Is there a way to count the number of days between 2 dates INCLUDING the first day? i.e. Dec. 31/02 and Jan. 1/03 = 2 days (vs. simply subtracting to get 1 day)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•