How do you know what day of the week any date is?
Here is a standard method suitable for mental computation:Take the last two digits of the year.Divide by 4, discarding any fraction.Add the day of the month.Add the month’s key value: JFM AMJ JAS OND 144 025 036 146.Subtract 1 for January or February of a leap year.More items….
Can Excel tell you what day of the week a date is?
ExampleA3-Jan-2008FormulaDescription (Result)=TEXT(A2, “dddd”)Calculates the day of the week for the date and returns the full name of the day of the week (Monday)=TEXT(A3, “ddd”)Calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu)2 more rows
What is the shortcut to find day from date?
1 January 2000:Start with ’00, leaving a Year Code of zero.January has a Month Code of zero.The Day Number is 1.The Century Code for dates in the 2000s is 6.2000 is a leap year, since it can be divided by 400, and the date is in a January or February, so subtract 1 from the total in the final step.More items…•
How do you find the day of aptitude from date?
Counting of Odd Days:1 ordinary year = 365 days = (52 weeks + 1 day.) 1 ordinary year has 1 odd day.1 leap year = 366 days = (52 weeks + 2 days) 1 leap year has 2 odd days.100 years = 76 ordinary years + 24 leap years. = (76 x 1 + 24 x 2) odd days = 124 odd days. = (17 weeks + days) 5 odd days.