I need to count records between two dates by the day and by the hour, i.e. Between 1/1/11 and 3/31/11 count records for all Sundays between 00:00 and 01:00. Date format is: 1/1/2011 2:02. See attached for example. Thanks in advance for any help!
I need to count records between two dates by the day and by the hour, i.e. Between 1/1/11 and 3/31/11 count records for all Sundays between 00:00 and 01:00. Date format is: 1/1/2011 2:02. See attached for example. Thanks in advance for any help!
Last edited by NBVC; 03-25-2011 at 10:07 PM.
Try:
in C3 and then copied to rest of the matrix.![]()
Please Login or Register to view this content.
Note: The date range is determined by F1 and G1
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 much! Few tweaks and it worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks