difference in days between two date columns

B

brian

I need to calculate days remaining for contracts from today's date. The only
field I have is the expiration date for the contract. How can I do this?

Thank you!
 
R

Ron de Bruin

Hi Brian

With the date in B1 for example use

=B1-TODAY()

Format the cell as general
 
Top