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

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
 
J

Jacob Skaria

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&""))
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count specific days in between dates 2
Excel Formula - Count Dates from another Sheet 8
Excel counting days 6
Count days between text dates 8
Trailing 30 days sum calculation with excel 1
Spreading date range across days in weeks (advanced) 7
Counting of a date from a range of Cells 2
Date + X days excluding holidays 1

Top