DATE COUNTING FORMULA

spnz · May 10th 2003

Does anyone know a formula I can use to count dates??
e.g I am wanting to count all entries within the last 7 days.

Dave Hawley · May 10th 2003

Hi spnz

see the attached example that uses the DCOUNT

spnz · May 10th 2003

Thanks alot Dave much apprecited!!!!!!

Dave Hawley · May 10th 2003

My pleasure.

:tumble:

spnz · May 10th 2003

Is there a formula that can count entries by months?? e.g entries 3 months ago???

Thank you

Dave Hawley · May 11th 2003

Hi spnz

Can you be more specific? Do you mean, count how many months there are in a range of dates? Or, count all dates that are less than 3 months ago?

2rrs · May 11th 2003

Hi, try this for the number of occurrences in the past 7 days;

With your dates in E:E

In F1 enter =E1-7 and drag down

In G1 enter =COUNTIF(E:E, ">=" & F1)-COUNTIF(E:E, ">" &E1) and drag down

HTH, 2rrs

Participate now!