View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MSSailor MSSailor is offline
external usenet poster
 
Posts: 15
Default How to count the last 30 days of activities

Have several columns with details
Column A5 and down=Date
Column B5 and down=Activity
Column C5 and down=Type of transportation

I now have 250 rows with activities from today and back in time.
My question is how can I have a variable in A1 where I can ask the last X
days activities. I will choose in A1 how many days back in time the number of
activities done.