I have excel worksheet that is a calendar count down. If or when the days have past I would like it to say -23 days have Past… my current formula I use now is: ="Just "& C9-$B$2 &" days left!"
today 10/03/2021
Day Events Dates Time Remaining
Kul Bus pass 15-Feb-21 Just -23 days left!
Free Eye Tests 17-Jan-21 Just -52 days left!
Fiesta Car Battery Appoinment 19-Apr-21 Just 40 days left!
Hux D3 Tablet To Be Taken 10-Mar-21 Just 0 days left!
1st COVID-19 vaccine injection 22-Mar-21 01:10 Just 12 days left!
blood test appointment 24-Mar-21 7:05 - 7:10 Just 14 days left!
Bookmarks