Days Calculator - day counter - days between dates

Days calculator and days counter between dates. Calculating Days can pretty easy if you are using the right formula, all you need to do is to apply the formula in subtracting the later date from the former date and get your answer without sweating.

Calculating Days can pretty easy if you are using the right formula, all you need to do is to apply the formula in subtracting the later date from the former date and get your answer without sweating
Many times we find wizards telling us the exact day of the week like Monday, Tuesday, Wednesday, Thursday, etc., based on the date. But these days we really don't need a wizard to know how to calculate the days.

Days calcultor


 

Once you have some basic knowledge of the days and can do some simple calculations but if that sounds a bit difficult you can get your answer making use of MS Excel

As a first step, it is very trivial to see that the day repeats with a periodicity of 7 days for instance, if today the 24th August 2015 is a Tuesday 17th August 2015 is also a Tuesday and the same fact is true for any date that falls before the current date with a days span equal to any multiple of 7. For example 7 * 12 = 84 days prior to today would also be a Tuesday. We will use this simple reasoning and calculate the span or the number of days between a ref date for which we know the day and for the date for which we require to find out the day. Dividing this span of days by 7 will provide us with a reminder between 0 and 6. If the ref date is today and the remainder is 2 that indicates that the day of the week we are trying to figure out in the calculation is Sunday which is 2 days prior to Tuesday our ref date.

After this let us formulate some general rules for counting the elapsed dates between two dates correctly.

1. Count the whole number of years elapsed between the two dates. For example between 23rd June 2005 and 2nd Feb 2009, the number of elapsed years is 3 and between 4th July 1999 and 7th September 2010, the number of elapsed years is 11.

1a. After counting the number of whole elapsed years between the dates, count the number of leap years in between. In the first example, 2008 is a leap year and in the second example 2000, 2004 and 2008 are leap years.

1b. After counting the number of leap years calculate the number of elapsed days as 366 * no of elapsed leap years + 365 * no of elapsed non-leap years.

2. Count the number of elapsed whole months between the date for which we require to find out the day and the day which corresponds to the whole year before or after the reference date. In the two examples in 1, the date that corresponds to the elapsed whole year is 2nd Feb 2006 and 7th September 1999. Also, calculate the number of 31 day months and the number of 30 day months elapsed. Count the number of days as 30* no of 30 day whole months elapsed + 31 * no of 31 day whole months elapsed. For the example in 1 the number of whole months elapsed between 23rd June 2005 and 2nd Feb 2006 are 7. Out of the 7 months, 5 (July, August, October, December, January) are 31 days and 2 (September, November) are 30 days.

3. After 2 what remains to be done is to add the number of remaining days, in the example above, there are 7 days remaining in June and 2 days in Feb. This should be added to the sum of 1 and 2.

One has to take precaution while calculating the elapsed days correctly, else one may calculate it incorrectly.

Let us consider a numerical example

30th June 2015 is Thursday. Let us find out the day of the week of 2nd September 2004 taking the first date as a reference date.

Let us calculate exactly the number of days between the two dates.

The number of whole years between 30th June 2015 and 30th June 2005 is 10 years.

The number of leap years are 2 (2008, 2012).

Number of days equal (8 x 365) + (2 x 366) = 3652

The number of months elapsed between 30th June 2005 and 2 September 2004 which have 31 days is October, December, January, March, May.

= 31 X 5 = 155

The number of months of 30 days which have a whole elapsed month between these two dates is November, April, and June with an additional 29 days in July excluding 30th July 2015.

= 30 x 3 + 29 = 119

The number of days in Feb 2005 is 28. and the number of elapsed days in September from 2nd to 30th is 29 (counting both days).

The above component would add to 57 days.

So the number of days in between whole elapsed months and dates is 155 + 119 + 57 = 331 days.

So counting the total number of days between these two dates 3652 + 331 = 3983 days.

If today the day of writing this article is Thursday, 30th June 2015, then the 23rd of June 2015 would also be a Thursday. This implies that the day repeats itself with a periodicity of 7.

So let us count the number of whole weeks and the number of days contained within 3983 days. So dividing 3983 by 7 we get 569 weeks and 0 days.

This implies that 2nd September 2004 falls on a Thursday as well.

It's a big challenge for most of us to calculate the number of working days. Though the concept looks so simple but calculating it has never been the same. The most common use approach by people is to physically count the number of days using a calendar. This approach is very prone to human error and therefore, we have a tendency to count a few more times to make sure that we have counted correctly. Imagine how tasking it can when you are trying to count for numerous sets of dates. it will definitely be a lot different if you are using MS Excel because it can help you get the answers quickly and accurately.

One of the ways to do that is to make use of the formula called NETWORKDAYS. The formula is very simple to use. All you have to do is to type in the formula, enter the start and end dates. The formula will immediately display the number of working days between the 2 given dates, based on a five days work week. If you wish to exclude holidays in the calculation, just enter the holidays you wish to exclude in the formula. You can input all the holidays for the year and the NETWORKDAYS formula will be able to pick the relevant holidays as and when they fall between the start and end dates. You may not find this formula in your Excel application if you did not activate the Analysis Toolbar Add in. Some of you may have to install the Add in into Excel. This Add in contains extra powerful formulas, that is unknown to most users, just like the NETWORKDAYS formula.


Comments(0)