My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

worksheet that is a calendar count down|General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / worksheet that is a calendar count down|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
worksheet that is a calendar count down
Avatar
Bhajan Singh

New Member
Members
Level 0
Forum Posts: 1
Member Since:
March 10, 2021
sp_UserOfflineSmall Offline
1
March 10, 2021 - 11:39 pm
sp_Permalink sp_Print

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!
Avatar
Lionel Baijot
Member
Members
Level 0
Forum Posts: 119
Member Since:
September 9, 2020
sp_UserOfflineSmall Offline
2
March 11, 2021 - 12:29 am
sp_Permalink sp_Print

Hi,

You can add a condition, as in the attached file.

BR,

Lionel

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Terry Hedditch, Tracy English, Mohamed Touahria
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594

 

Member Stats:
Guest Posters: 49
Members: 32817
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen