View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Lynz Lynz is offline
external usenet poster
 
Posts: 35
Default Counting dates before today

Shane Devenshire wrote:
Hi,

Your formula would look like this

=COUNTIF(E4:E34,"<="&A2)

Thanks Shane