Counting Dates Within 60 Days

**tkaye** · 12-05-2008, 05:29 PM

I've looked everywhere on the web and I cannot seem to come up with a formula for this one:

I want to get a count of dates within a range of cells that are due within 60 days of current date (Today).

Any clues?

Thanks!

**mkvassh** · 12-05-2008, 05:41 PM

You can probably use the COUINTIF-function

**tkaye** · 12-05-2008, 05:46 PM

Yes, I tried that, but I can't seem to get it to work...I need help with the exact formula...

**daddylonglegs** · 12-05-2008, 05:57 PM

Do you mean dates that are between today and today+60? If so try

=COUNTIF(A1:A100,">="&TODAY())-COUNTIF(A1:A100,">"&TODAY()+60)

Where your dates are in A1:A100