Hi guys,
Is there a formula that can count how many rows in column E equal todays date plus 7 days? I know that the below formula counts how many rows have today's date, but I cannot find a formula to count how many rows have a date between today's date (11/11/2014) to 7 days out (12/18/2014).
Please Login or Register to view this content.
Try this:
Is that something you can work with?Please Login or Register to view this content.
I had tried that prior to posting, but for some reason it returns 0. I have 9 dates in column E that have a date between 11/11/2014 to 11/18/2014 so the formula should return a 9.
How about something like this?
=COUNTIF(E:E,TODAY()) +COUNTIF(E:E,TODAY()+1) +COUNTIF(E:E,TODAY()+2) +COUNTIF(E:E,TODAY()+3) +COUNTIF(E:E,TODAY()+4) +COUNTIF(E:E,TODAY()+5) +COUNTIF(E:E,TODAY()+6) +COUNTIF(E:E,TODAY()+7)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
That would imply that either the Col_E values are not dates....
or...they include a time component (Example: 12/18/2014 4:48:00 AM).
Assuming the latter, try this:
or...if you want a count of dates that are between today and today +7 days, inclusive,Please Login or Register to view this content.
try this:
Does that help?Please Login or Register to view this content.
The column E values are definitely dates, and they do not have a time component.
Capture.JPG
This works, thanks. I would have thought there would be a simplified version of this?
Please Login or Register to view this content.
Hi,
Ron's formulas above that use the CountIFS() is an easier version.
Somehow I had missed your second formula, Ron. It worked beautifully. I never would have thought of it. Thanks so much for the help. +1 for both of you.
This thread will be changed to "solved".Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks