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
|