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

  • Thread starter Thread starter Juan Roubaud
  • Start date Start date
J

Juan Roubaud

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
 
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&""))
 
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
 
Back
Top