Note: This formula would only work when you using a date that Excel recognizes as a valid date format. You can easily adjust this and get the values in numbers by going to the Home tab, and select General in the number format drop-down. This sometimes happens when Excel tries to be helpful and pick up the format from the adjacent column. There is a possibility that Excel will give you the result in the date format instead of a number as shown above.
