Well, even when it comes to dates, Excel allows you to use simple arithmetic to calculate the number of days between dates buy subtracting one date from another.

This is possible due to the way that Excel stores dates. Each date is equal to 1 and part of a day i.

How to count the number of days / workdays / weekends between two dates in Excel?

To Excel, the date July 10, is actually a number 40, The number represents the number of days since January 1, With this information, it takes just a simple subtraction formula in Excel to determine the number of days excel formula count business days between two dates two dates.

You subtract the oldest date from the newest date. If you want to count the days between a certain date and today, you can use the TODAY function in your formula.

You can follow this link to determine the number of months and years between two dates. You can also extract the year, month or day from a date which can be useful in formulas.

Calculating the Number of Work Days between two dates

Stock option exercise journal entries entry was posted on Friday, January excel formula count business days between two dates, at 4: You can follow any responses to this entry through the RSS 2. You can leave a responseor trackback from your own site.

Mail will not be published required. You can use these tags: The Excel Addict Blog is proudly powered by WordPress Entries RSS and Comments RSS. The Excel Addict Blog Helping you discover the hidden powers of Microsoft Excel.

Calculate Number of Days Between Two Dates As you know, Excel is great at arithmetic. Leave a Reply Click here to cancel reply.