We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

When you want to know the number of days between two dates whether the date is in the future or the past, you can use Excel to calculate it.

How to exclude holidays in Excel So far, we’ve used NETWORKDAYS () to exclude weekends when counting the number of days between today and the estimated completion date for our projects.

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.