hi,

I am having datetime,dayofweak,start time,end time i need to find the count so that in  a daysofweak from time start to end how many values are there and i used the following formula.

=COUNTIFS(E:E,"Sunday",F:F,">="&H2,F:F,"<="&I2)

Here for sunday ,from 00:00:00 to 00:59:59 i have found value with this formula  ,now what i need is the date should be distinct for example now the date is duplicate for starttime to endtime but now if i got one date for a time stamp then i should not be counting that date again.

thanks

• Moved by Lanlan HuangMicrosoft contingent staff Tuesday, April 07, 2015 3:07 AM

Hi,

Do you mean you want to count the dates between starttime to endtime without counting which is duplicate?

If yes, we can use a PivotTable to help you. Please refer to this link:

http://superuser.com/questions/312909/make-countifs-count-duplicate-values-only-once

It seems this question is similar to your problem.

Hope its helpful.

If you have any update, please let me know.  I am glad to help and forward to your reply.

Regards.

• Edited by guGuuuMy Wednesday, April 08, 2015 9:09 AM

can you include a column that shows the answer you would like it to have?