## 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.