Tweet
Hello, visitor!
Day calculation from date. Note: This is not a java specific post. The below mentioned methods are not specific to any technology and can be implemented in any programming language.
ENTER TO THE SITE
INTRODUCTION. There are two formulas for calculating the day of the week for a given date. Zeller’s Rule Key-Value Method. Note: Both the methods work only for the Gregorian calendar. (People in English-speaking countries used a different calendar before September 14, 1752.) 1) Zeller’s Rule. F=k+ [(13*m-1)/5] +D+ [D/4] +[C/4]-2*C where. k is the day of the month. m is the month number. D is the last two digits of the year. C is the first two digits of the year. Note: According to Zeller’s rule the month is counted as follows: March is 1, April is 2….. January is 11 and February is 12. So the year starts from March and ends with February. So if the given date has month as January or February subtract 1 from the year. For example: For 1st January 1998 subtract 1 from 1998 i.e. 1998-1=1997 and use 1997 for calculating D. Discard all the decimal values and then find the final value of F. After getting the value of F, divide it by 7.The value of F can be either positive or negative. If it is negative, let us suppose F = -15. When we divide by 7 we have to find the greatest multiple of 7 less than -15, so the remainder will be positive (or zero). -21 is the greatest multiple of 7 less than -15, so the remainder is 6 since -21 + 6 = -15. Alternatively, we can say that -7 goes into -15 twice, making -14 and leaving a remainder of -1.If we add 7 since the remainder is negative i.e. -1 + 7 we again get 6 as remainder. After getting the remainder we can find the day of the week for the given date. Following are the values for the corresponding remainders: Sun Mon Tue Wed Thurs Fri Sat 0 1 2 3 4 5 6. Examples for day calculation using Zeller’s Rule: Let us calculate the day for the following dates: 1st April 1983 and 27 th February 2023. A) 1 st April 1983: Here k = 1 m=2 D=83 C=19. Putting the values in the formula, we get, F= 1+ [(13*2-1)/5] +83+83/4+19/4-2*19 = 1+ [(26-1)/5]+83+20.75+4.75-38 = 1+25+83+20+4-38 (discarding the decimal values) = 133-38 = 75. After calculating F divide it by 7 and get the remainder. 78/7=11 Quotient 5-Remainder. Therefore, the day on 1 st April 1983 was Friday since the remainder is 5. B) 2nd March 2004: Here, k = 2 m= 1 D= 04 C= 20. Putting the values in the formula, we get, F= 2+ [(13*1-1)/5] +04+04/4+20/4-2*20 = 2+ [(13-1)/5] +04+01+05-40 = 2+ [12/5] +10-40 = 2+2+10-40 (discarding the decimal values) = 14-40 = -26. Here F is negative. So when we divide by 7 we have to find the greatest multiple of 7 less than -26, so the remainder will be positive (or zero). -28 is the greatest multiple of 7 less than -26, so the remainder is 2 since -28 + 2 = -26. So, the remainder is 2. Therefore, the day on 2 nd March 2004 was Tuesday since the remainder is 5. C) 27 th February 2023: k = 27 m = 12 D = 22 (Since month count starts from March) C = 20. Putting the values in the formula, we get, F = 27+ [(13*12-1)/5] +22+22/4+20/4-2*20 = 27+ [(159-1)/5] +22+5.5+5-40 = 27+ [158/5] +22+5.5+5-40 = 27+ [31.6] + 22 + 5.5 + 5 – 40 = 27+ 31+22+5+5-40 ( discarding the decimal values) = 90-40 = 50. After dividing F by 7, we get remainder as 50/7=1. Therefore, the day on 27 th February 2023 is Monday since the remainder is 1. 2) The Key Value Method. The Key Value method uses codes for different months and years to calculate the day of the week. It would be easier if one is able to memorize the codes which are very easy to learn. S teps: Suppose the year is not in the above table. In this case all we have to do is add or subtract 400 until we have a year (century) that is in the table. Then get the code for the year from the above table and add the value to the previous step (our running total). Now, we will try to implement the above method by taking two examples, one for a normal year and other for a leap year. Let us take 19th November 2582 as an example. Take the last 2 digits of the year. In our case, this is 82. Divide it by 4 and discard any remainder. 82 / 4 = 20, remainder 2, so we take only 20 discarding 2 (remainder). Add the day of the month. In our example, 20 + 19 = 39. The month in our example is November, which has the key value of 4. Therefore, 39 + 4 = 43. Our example year is 2582, and the 2500s aren’t in the table. In this case all we have to do is add or subtract 400 until we have a year (century) that is in the table. 2582 – 400 = 2182.
Day finder by date formula
Day calculation from date. Note: This is not a java specific post. The below mentioned methods are not specific to any technology and can be implemented in any programming language.
ENTER TO THE SITE
INTRODUCTION. There are two formulas for calculating the day of the week for a given date. Zeller’s Rule Key-Value Method. Note: Both the methods work only for the Gregorian calendar. (People in English-speaking countries used a different calendar before September 14, 1752.) 1) Zeller’s Rule. F=k+ [(13*m-1)/5] +D+ [D/4] +[C/4]-2*C where. k is the day of the month. m is the month number. D is the last two digits of the year. C is the first two digits of the year. Note: According to Zeller’s rule the month is counted as follows: March is 1, April is 2….. January is 11 and February is 12. So the year starts from March and ends with February. So if the given date has month as January or February subtract 1 from the year. For example: For 1st January 1998 subtract 1 from 1998 i.e. 1998-1=1997 and use 1997 for calculating D. Discard all the decimal values and then find the final value of F. After getting the value of F, divide it by 7.The value of F can be either positive or negative. If it is negative, let us suppose F = -15. When we divide by 7 we have to find the greatest multiple of 7 less than -15, so the remainder will be positive (or zero). -21 is the greatest multiple of 7 less than -15, so the remainder is 6 since -21 + 6 = -15. Alternatively, we can say that -7 goes into -15 twice, making -14 and leaving a remainder of -1.If we add 7 since the remainder is negative i.e. -1 + 7 we again get 6 as remainder. After getting the remainder we can find the day of the week for the given date. Following are the values for the corresponding remainders: Sun Mon Tue Wed Thurs Fri Sat 0 1 2 3 4 5 6. Examples for day calculation using Zeller’s Rule: Let us calculate the day for the following dates: 1st April 1983 and 27 th February 2023. A) 1 st April 1983: Here k = 1 m=2 D=83 C=19. Putting the values in the formula, we get, F= 1+ [(13*2-1)/5] +83+83/4+19/4-2*19 = 1+ [(26-1)/5]+83+20.75+4.75-38 = 1+25+83+20+4-38 (discarding the decimal values) = 133-38 = 75. After calculating F divide it by 7 and get the remainder. 78/7=11 Quotient 5-Remainder. Therefore, the day on 1 st April 1983 was Friday since the remainder is 5. B) 2nd March 2004: Here, k = 2 m= 1 D= 04 C= 20. Putting the values in the formula, we get, F= 2+ [(13*1-1)/5] +04+04/4+20/4-2*20 = 2+ [(13-1)/5] +04+01+05-40 = 2+ [12/5] +10-40 = 2+2+10-40 (discarding the decimal values) = 14-40 = -26. Here F is negative. So when we divide by 7 we have to find the greatest multiple of 7 less than -26, so the remainder will be positive (or zero). -28 is the greatest multiple of 7 less than -26, so the remainder is 2 since -28 + 2 = -26. So, the remainder is 2. Therefore, the day on 2 nd March 2004 was Tuesday since the remainder is 5. C) 27 th February 2023: k = 27 m = 12 D = 22 (Since month count starts from March) C = 20. Putting the values in the formula, we get, F = 27+ [(13*12-1)/5] +22+22/4+20/4-2*20 = 27+ [(159-1)/5] +22+5.5+5-40 = 27+ [158/5] +22+5.5+5-40 = 27+ [31.6] + 22 + 5.5 + 5 – 40 = 27+ 31+22+5+5-40 ( discarding the decimal values) = 90-40 = 50. After dividing F by 7, we get remainder as 50/7=1. Therefore, the day on 27 th February 2023 is Monday since the remainder is 1. 2) The Key Value Method. The Key Value method uses codes for different months and years to calculate the day of the week. It would be easier if one is able to memorize the codes which are very easy to learn. S teps: Suppose the year is not in the above table. In this case all we have to do is add or subtract 400 until we have a year (century) that is in the table. Then get the code for the year from the above table and add the value to the previous step (our running total). Now, we will try to implement the above method by taking two examples, one for a normal year and other for a leap year. Let us take 19th November 2582 as an example. Take the last 2 digits of the year. In our case, this is 82. Divide it by 4 and discard any remainder. 82 / 4 = 20, remainder 2, so we take only 20 discarding 2 (remainder). Add the day of the month. In our example, 20 + 19 = 39. The month in our example is November, which has the key value of 4. Therefore, 39 + 4 = 43. Our example year is 2582, and the 2500s aren’t in the table. In this case all we have to do is add or subtract 400 until we have a year (century) that is in the table. 2582 – 400 = 2182.
Day finder by date formula