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

  • Thread starter Thread starter IGG
  • Start date Start date
I

IGG

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()")
 
Try this:
=COUNTIF(B5:B100,"<"&TODAY())

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

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Neary there:

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top