Comparing dates in excel

How do I compare date in the following format with today's date and work out the no. of days in between?

31.12.2016

Formula: A1-Today() doesn't seem to work. It returns #VALUE!

shana cheong

Posted 2014-08-08T09:45:01.617

Reputation: 3

Is your system setup to recognize the date format with . as separators? Maybe Excel is seeing it as text. – CharlieRB – 2014-08-08T11:58:14.247

Answers

=NETWORKDAYS(A1,B1)

If the NETWORKDAYS function is not available, install and load the Analysis ToolPak add-in.

Ash King

Posted 2014-08-08T09:45:01.617

Reputation: 1 175

NETWORKDAYS doesn't work either. What do I need to do after adding the Analysis ToolPak add-in? – shana cheong – 2014-08-08T09:55:30.667

On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK. If necessary, follow the instructions in the setup program. Should work ok after you have restarted excel – Ash King – 2014-08-08T09:59:45.230

You should take a look at the DATEVALUE function.

http://office.microsoft.com/en-us/excel-help/datevalue-function-HP010062284.aspx

Pirmin Van den Borre

Posted 2014-08-08T09:45:01.617

Reputation: 1

While the link might provide an answer it can quickly become outdated. Please include the key points in your answer and use the link as reference. Thanks – Matthew Williams – 2014-08-08T11:12:55.753

The key point is the use of the DATEVALUE function. – Pirmin Van den Borre – 2014-08-09T11:43:02.940