View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs
 
Posts: n/a
Default Function Help - Counting Days


Try this for a count of dates more than 60 days old

=COUNTIF(E:E,"<"&TODAY()-60)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=544372