Excel - days passed from baseline date

infiniti7181
infiniti7181 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Project Controls Engineer
Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial