Excel - days passed from baseline date

Dear Gurus,

Lets say , i  add date in excel sheet and i would like to know the counter of days passed , when i access it after couple of days

In short ,

I have date assigned : 14 Mar 19

When i check  my sheet random , eg : 17 Mar 19   , i should show in  cell x # of days passed ( and in different color to identify easily )

is this possible in  excel

BR ,
Sid
infiniti7181Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hakan YılmazSenior Project EngineerCommented:
Write your baseline in A1
Write this formula to B1
=TODAY()-A1

Open in new window

Select cell B1, press CTRL+1, and change number format of B1 to Custom as shown below.
Cell Formatting

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.