How do I count number of days from a range of dates & some repite.
 

I am using excel 2007 and I need to get the count of days from a range of
dates where some dates are repited; one diferent date is equal to one day.
I will aprreciate any input

How do I count number of days from a range of dates & some repite.
 

Hi Juan

If you mean to get the distinct count of dates then try the below with dates
in the range A2:A10...Change the range to suit..

=SUMPRODUCT((A2:A10<"")/COUNTIF(A2:A10,A2:A10&""))

--
Jacob


"Juan Roubaud" wrote:

I am using excel 2007 and I need to get the count of days from a range of
dates where some dates are repited; one diferent date is equal to one day.
I will aprreciate any input

How do I count number of days from a range of dates & somerepite.
 

You can just subtract one date from another to get the number of days
difference (format the cell as general or as number with 0 dp).

I'm not sure exactly what you are asking, but perhaps this:

=MAX(D:D) - MIN(D:D)

assuming your dates are in column D.

Hope this helps.

Pete

On Dec 2, 3:51*pm, Juan Roubaud <Juan
wrote:
I am using excel 2007 and I need to get the count of days from a range of
dates where some dates are repited; one diferent date is equal to one day..
I will aprreciate any input * *