View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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