One way:

A1: <expiration date
A2: =TODAY()-A1

Format A2 as General.


In article ,
"expiration dates" <expiration wrote:

I need to set up a sheet that will show how many day's i have left before a
contract will expire.