View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John DeLosa
 
Posts: n/a
Default How do I add a range by date over 90 days older than today

I am setting up a work book that needs a cell to show an over 120 days old
total with out having a column above it. I have tried sumif but can't find a
criteria that will let me refferance a TODAY date or a cell with today's date
in it to subtract from.
my columns a Invoice #, Invoice Date, and Invoice Amount I would Like a
cell on the bottom that shows a total amount over 120 days old