Good morning,
I have a list of contracts that have a start and end date. I will like to know how many days are left in their contract before it expires.
If possible, I would like this to be automatic. Any help is grateful!
I know it must have the today() function.
Start End
05/01/2019 05/01/2020
Days left before expiration
Thank you in advance.
With the end date in B2:
=B2-TODAY()
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
How aboutFormula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks