Calculate number of days in a column of dates

Barbara

Posts: n/a

Calculate number of days in a column of dates

Hi again,

I still have a problem!!! In this list, with your formula, it returns 16
days. But the right answer is 14. Why? How can I have the right answer?
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
02-Dez
03-Dez
07-Dez
07-Dez
09-Dez
10-Dez
10-Dez
13-Dez
13-Dez
13-Dez
14-Dez
14-Dez
15-Dez
15-Dez
15-Dez
15-Dez
16-Dez
16-Dez
17-Dez
17-Dez
17-Dez
20-Dez
20-Dez
21-Dez
21-Dez
21-Dez
21-Dez
21-Dez
22-Dez
22-Dez
23-Dez
23-Dez

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
I need a formula to sum column b if column a is between two dates	Pam	Excel Discussion (Misc queries)	2	April 18th 05 06:18 PM
Count cells in a column that contain dates	Cachod1	New Users to Excel	1	March 29th 05 08:56 PM
How do you calculate number of workdays from dates entered?	tfleck	Excel Worksheet Functions	1	March 25th 05 09:17 PM
How do you calculate number of workdays from dates entered?	[email protected]	Excel Worksheet Functions	0	March 25th 05 07:55 PM
Calculate the number of workdays between 2 dates	Tegid77	Excel Worksheet Functions	1	November 4th 04 07:27 PM

All times are GMT +1. The time now is 05:22 AM.

Menu

About Us