Two dates between Now and +7 Days

Colin Whelan

Hi I am trying to return a count of dates between two dates that will move based on todays date, I have tried umpteen different approaches but cannot get the sheet to return a valid answer.

=COUNTIF(MigrationDate1:MigrationDate3, >TODAY() <= TODAY(+7))

19/08/20

19/08/20

05/08/20

The answer it returns is 3. I would have expected it not to count 05/08/20.

Seems like a really simple calculation but i cannot get it to work. Any help appreciated.

MCorbin

You really have 2 criteria....

greater than today

and less than 7 days from today

(and did you want to include today's date and the date 7 days from now? I'm assuming yes (greater than or equal to), but you can remove the equal sign in my formula if you don't want to include one or both of those dates):

So your formula should look more like this:

=COUNTIFS(MigrationDate:MigrationDate, >=TODAY(), MigrationDate:MigrationDate, <=TODAY(7))