Formula

[MarkAndrews]

I am trying to count the number of days which are greater than today using

=COUNTIF(K:K,">=today()")

I've tried it without the quotes too & it displays 0

Can anyone please enlighten me

Thanks!

 

[texasalynn]

try this

=COUNTIF(K:K,">="&TODAY())

 

[MarkAndrews]

try this

=COUNTIF(K:K,">="&TODAY())

Fantastic

Thankyou very much