Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
113
Views
Topic starter
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! |
Posted : 11/03/2021 9:39 am
Hi,
You can add a condition, as in the attached file.
BR,
Lionel
Posted : 11/03/2021 10:29 am
