Compute for 45 days and 30 days notice for expiration date

Question

I have a data base with list of contract workers with validity date or end of employment contract. I want Excell to compute for remaining days before their contract expiration

Can you help me create a formula. Ex. John Smith, End of Contract Dec 24, 2017. Another column to compute for how many days left before his contract expires

ingeborghawighorst · Answer

Hello,&nbsp;you can calculate the Expiry date minus today, for example, if the expiry date is in cell A1, you can use&nbsp;=A1-Today()&nbsp;&nbsp;&nbsp;&nbsp;

michael_avidan · Answer

@ Wilfredo Dela CruzYou may want to check the Build-in feature called: Conditional Format.It can help you to color the employees name (and/or the cells background) N days before due date.It is more visual than pure numbers.--------------------------Michael (Micky) Avidan“Microsoft® Answers" - Wiki author &amp; Forums Moderator“Microsoft®” Excel MVP – Excel (2009-2018)ISRAEL

Forum Discussion

Compute for 45 days and 30 days notice for expiration date

2 Replies