it did exactly what we asked. It subtracted the start date from the end date, kind of like 10 -1 in this case, and came up with the number 9, as expected. The lesson here is that to include both the start date and the end date in the count of days, you have to add 1 to th...
Read More:Excel Formula to Count Days from Date Method 6 – Calculate Number of Days Between Today and Another Date We can use theTODAY functionto input today’s date, and then a past date can be subtracted from itto find the number of days until today from that fixed past date. Steps:...