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...
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!
2 Answers
=NETWORKDAYS(A1,B1)
If the NETWORKDAYS function is not available, install and load the Analysis ToolPak add-in.
You should take a look at the DATEVALUE function.
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
