counting the number of days, I want to exclude today and the past

ilwiny

Also, how do I exclude dates in the past (including today)?

=COUNTIFS({Go Live Range}, <=TODAY(30)) is returning 4 and one of those dates is in the past and one date is today.

02/15/24 - should exclude the past

02/26/24 - should exclude today

03/01/24

03/05/24

04/01/24

04/01/24

Thank you

Carson Penticuff

Add a condition for "greater than today"

=COUNTIFS({Go Live Range}, <=TODAY(30), {Go Live Range}, > TODAY())

Carson Penticuff

Add a condition for "greater than today"

=COUNTIFS({Go Live Range}, <=TODAY(30), {Go Live Range}, > TODAY())

ilwiny

That works!!

Thank you very much