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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template for calculating different number of days between 2 dates 1
dynamic calculation of months remaining given end date and today 2
calculate days per year 4
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Formula for Fiscal Year Conditional Formatting 2
Help for auto Display of Contract Due in Form 2
Calculate a Date In Excel 1
Expanding Date formula 1

Back
Top