difference in days between two date columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Brian

With the date in B1 for example use

=B1-TODAY()

Format the cell as general
 
Back
Top