Formula "Countif" with value bigger than "current date"

Joerg Schmidt

I use a sheet summary and want to figure out how many cells are there with a date bigger than the current date

my formula =COUNTIF(Start1:Start195; > TODAY)

doesn't work. Why?

kind regards Joerg

Andrée Starå

Hi Jörg,

You were close.

Try this.

=COUNTIF(Start1:Start195;>TODAY()) 

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Jörg,

You were close.

Try this.

=COUNTIF(Start1:Start195;>TODAY()) 

Did it work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Joerg Schmidt

Dear Andrée,

thank you. It works.

I am happy ;-)😀

Andrée Starå

Excellent! 

Happy to help! 

Joerg Schmidt

Hi Andrée,

do you also have a solution for following problem?

column 1: date of hotel opening, f.e. 2019, 2020, 2021

column 2: amount of rooms in hotels

I want to sum the number of rooms only for hotels opened later than today or before today🤔

what formula do I have to use?