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

Learning how to subtract a date from today in Excel can help you find the number of days between a given date and today’s date.

How to add a monthly balance in Excel As you’ve seen, a daily balance requires only a simple IF () function to match dates before returning the balance for each day.

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.