Criteria for DCOUNTA for date values

W

wacNTN

I have a database in Excel that has several columns that are date values. I
need to count the number of records that have a date that is prior to a
constant date. How do I do this?

Thanks,

Walter
 
P

Peo Sjoblom

If the database is called MyTable, the constant date is Jan 1 2006, the
dates header is called dates and the criteria range is D1:D2, in D1 put
Dates and in D2 put

<1/9/06 (replace the date format with regional date format if not US dates)

If the constant date is in a cell like H2

="<"&H2

then use

=DCOUNT(MyTable,"Dates",D1:D2)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top