Thread: difference in days between two date columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default difference in days between two date columns
Hi Brian

With the date in B1 for example use

=B1-TODAY()

Format the cell as general



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"brian" wrote in message ...
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!
Reply With QuoteReply With Quote