J
John DeLosa
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 are: Invoice #, Invoice Date, and Invoice Amount I would Like a
cell on the bottom that shows a total amount 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 are: Invoice #, Invoice Date, and Invoice Amount I would Like a
cell on the bottom that shows a total amount over 120 days old