I am trying to count the number of orders written per day. I used the following formula on another sheet and it worked fine, however on this one, A8 is a date only, and F2:F2000 is a date and a time. I tried reformating the cell for date only, and it displays only the date, however, the time information is still stored, and I can't get it to do the count. Is there a way to count the date regardless of the time?
=COUNTIF('ACT Legacy'!$F$2:$F$2000,Stats!A8)
Last edited by NBVC; 10-05-2008 at 09:33 PM.
Try this :
=ROUNDDOWN(A1;1)-ROUNDDOWN(A2;1)
I can't round down the soure data, as I do need to access the time info on occasion. But I tried to implement the round down and can't get it do a count on my summary page. What am I doing wrong?
=COUNTIF(ROUNDDOWN('ACT Legacy'!F2,0)-ROUNDDOWN('ACT Legacy'!F2000,0),A9)
I tried the following variation, to try to count all orders on a given day. A13 & A14 are in date format only, while column E has date and time info. But it coumes up 0.
=COUNTIFS('ACT Uverse'!$E$2:$E$20000,'ACT Uverse'!$E$2:$E$20000>A13,'ACT Uverse'!$E$2:$E$20000,'ACT Uverse'!$E$2:$E$20000<A14)
Any suggestions?
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks! That's just what I was looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks