Thread: Count if past today () - 30 days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott_goddard Scott_goddard is offline
external usenet poster
  
Posts: 32
Default Count if past today () - 30 days
Hi all,

Trying to count the amount of risks the are open and and past todays date by
30 days...

So far i have

=COUNTIF(C9:C98,"Open"'(R2) Risks Log'!C9:C98,"="&TODAY() - 7)) but i can
not get this to work :(
Reply With QuoteReply With Quote