Count number of dates with 60 days of today

[jonisanders]

I want a formula that will count the number of days that are less that or equal to today plus 60 days.
I have tried =SUMPRODUCT(a1:a10,"<="&TODAY()+60) (this one gives me an error) and =countif(a1:a10,"<="&TODAY()+60) (this one give me 0). Any suggestions?

 

[jeffreybrown]

How about...

=SUMPRODUCT(--(A1:A10<=TODAY()+60))

 

[T. Valko]

I want a formula that will count the number of days that are less that or equal to today plus 60 days.
I have tried =SUMPRODUCT(a1:a10,"<="&TODAY()+60) (this one gives me an error) and =countif(a1:a10,"<="&TODAY()+60) (this one give me 0). Any suggestions?

That COUNTIF formula is syntactically correct.

So, either your dates aren't true dates or there are no dates that meet the condition.

Try this test formula.

Find a date that meets the condition. Let's assume that date is in cell A1.

What result do you get with this formula:

=ISNUMBER(A1)

If the cell contains a true date the result of that formula will be TRUE.

 

[jonisanders]

Thank you so much for the reply. I took your suggestion and reformated the range to insure they were all dates and reinstated the CountIF equation. It worked great. Thanks so much for helping me get there.

 

[T. Valko]

Thank you so much for the reply. I took your suggestion and reformated the range to insure they were all dates and reinstated the CountIF equation. It worked great. Thanks so much for helping me get there.

You're welcome. Thanks for the feedback!