How to calculate the number of dates in a column earlier than toda
 

Basically I need to calculate the number of dates in a column which have an
earlier date than todays date. If you look at my below attempt it might
better explain what I'am trying to achieve: -

=countif(B5:B100,"<Today()")

How to calculate the number of dates in a column earlier than toda
 

Try this:
=COUNTIF(B5:B100,"<"&TODAY())

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"IGG" wrote in message
...
Basically I need to calculate the number of dates in a column which have
an
earlier date than todays date. If you look at my below attempt it might
better explain what I'am trying to achieve: -

=countif(B5:B100,"<Today()")

How to calculate the number of dates in a column earlier than toda
 

Neary the

=COUNTIF(B5:B100,"<"&TODAY())

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"IGG" wrote in message
...
Basically I need to calculate the number of dates in a column which have
an
earlier date than todays date. If you look at my below attempt it might
better explain what I'am trying to achieve: -

=countif(B5:B100,"<Today()")