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

How to Calculate Past Due Date on MS Excel. Excel's EDATE and NOW functions can be used to track when an account is overdue, and let the person managing the account know when to send a reminder ...

Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.