Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

using dates excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using dates in excel

Using dates in excel

ResolvedVersion 2016

Jade has attended:
Excel Intermediate course

Using dates in excel

Hi All,

I am using an excel spreadsheet to assit me in acting as a count down

I have recorded the "actual date" and used F4 to lock it.

However I keep getting the days till xx listing a minus number.

For examples:

Today date is stored in Cell A2 (using -TODAY() )
Then I have my column one which is know as START DATE (Coulmn E)

Then I have my column days till tenancy start date (Column F):

I hav entered the formula as:
=($A$2-[@[Tenancy start date ]])

Todays date : 09/09/2018
Tenancy start date: 11/09/2018
Answer shows as: -2

I know there a way to change this
Sadly when i do the formula start date - todats date i recieve an eorro message.

Am i doing something wrong?

Been asked of me tp do this by Tuesday :)

THANK YOU
Jade


RE: Using dates in excel

Hi Jade,

Thank you for the forum question.

Try: (add a minus in front of the formula)

=-($A$2-[@[Tenancy start date ]])



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Sun 16 Sep 2018: Automatically marked as resolved.

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.