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()")