Compute for 45 days and 30 days notice for expiration date

[Wilfredo Dela Cruz]

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

[#2]

Hello,

you can calculate the Expiry date minus today, for example, if the expiry date is in cell A1, you can use

=A1-Today()

[Wilfredo Dela Cruz]

@ Wilfredo Dela Cruz

You 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 & Forums Moderator
“Microsoft®” Excel MVP – Excel (2009-2018)
ISRAEL