Countif Greater Than/Less Than Date Range

[mycon73]

Hi Excel Users...

I think I want to create a Countif function, but perhaps another function would be more suitable.

Here's what I have. I have a cell with a specific date in it - the date that I extract info.

In one of the columns, I column with various dates in it.

I would like a function that will read these dates in the column & have a formula that figure out if it's greater than my extraction date, but less than a specified date - Let's say from today's date & 2 weeks from extraction date.

Thanks

[NBVC]

Possibly?

=Countif(A:A,">="&Today())-Countif(A:A,">"&X2-14)

where A:A contain your column of dates...a

X2 contains extraction date

[sglife]

You can also try this

Please Login or Register  to view this content.

* b1 is your extraction date