So, before you do the subtraction, check whether the dates are in the proper date format. For example, if you have entered dates as text, Excel will show you an error. It is important to note that you have to enter dates in the Excel sheet in a date format. Use the Excel ABS function and get the absolute value.Now, when you have a future date, subtract the TODAY function from the future date. In the previous formula, I subtracted the given date from the TODAY function.To avoid the negative sign, you can do one of the modifications to the above formula. Then, when you apply the above formula, you will get the count as a negative number.
Let’s say that you want to find the number of days between today and a future date.
In this case, Excel shows 105 instead of. As soon as you select “General”, Excel shows the result of the formula as a number.
