Countifs between two dates (trick is, time stap is included)

[jph89]

All,

I am trying to build out some reporting for data that is exported in the same format as I have attached.

I have it built so the user can enter in a 'start' and 'end' date and the data will calculate appropriately. Unfortunately, when the data I need is exported, it has a timestamp included. I think it is also in an odd format.

Can anyone get a countif to work with the data I have attached?

Example: How many dates are between 8/21 and 8/29?

Thank you for whomever took the time to read this.


-JDate Help.xls

[daddylonglegs]

Including a time, per se, doesn't mean you can't count the dates but your data appears to be text formatted. Try converting to real dates/times by doing this:

Copy any blank cell then select date column > right-click > paste special > operations > add > OK > ESC

Now you can use this formula

=COUNTIFS(A:A,">="&DATE(2012,8,21),A:A,"<"&DATE(2012,8,30))

Note: the second date is deliberately a day later than your range - in order to capture dates with times on 8/29 you need to use <8/30 because of the time. That formula counts all dates anywhere on 8/21 and 8/29 and all dates in between