Calculating Age of Transaction

[StoopidGuy42]

I need to determine the age of a transaction from a historical standpoint.

Normally I would use =TODAY()-A1

However, I have to produce historic data and when entering this formula, I'm getting the data as if it were today.

Example: I have a payment date of 11/23/2018 and need to calculate the age from that date as if it were from that time, not today.

I hope this makes sense and I'm not THAT stupid.

Thanks in advance.

 

[tyija1995]

Hey,

What's in cell A1?

Can you not just reference the payment date and subtract A1?