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 4 hours 19 minutes ago

Hi Krishnakumar,

Since this forum is discussing about Excel developing, and your issue seems more related with the product feature of Excel, I will move this thread to the more related forum.

Reference: http://social.technet.microsoft.com/Forums/en-US/home?forum=excel

Thanks for your understanding.

Best Regards,

Edward