Need column that will post aging date

[tom]

I have spreadsheet with invoice dates on it. I need
another column that will show aging date against
specific date that will be input in one of the cells.

 

[Bernie Deitrick]

Tom,

Use

=CellWithDate - CellWithSpecificDate

like

=B3-$C$1

Format for 0 decimals, and that will report days.

Otherwise, you could use the DateDif function. See

http://www.cpearson.com/excel/datedif.htm

HTH,
Bernie
MS Excel MVP