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!

1

2 Answers

=NETWORKDAYS(A1,B1)

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

2

You should take a look at the DATEVALUE function.

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy