Calendar Calc

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
2,280
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jun 19, 2009

This simple formula will help you to calculate any date into the day of the week.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (4)

Sign In or Sign Up now to post a comment!
  • dooms day is quicker and easier to remember

  • why are the numbers for the months the way they are? is there a specific pattern? because I am still confused on that part. I am waiting for your answer

  • I'd like to use the Strangest secret in the world as a motivator in a sales training module. The purpose of this message is to obtain your permission to do so. I look forward to your answer.

  • The formula may be too simple, and appears not to account for leap years.

    (C+Y+Y/4+D+SV)/7

    e.g. for 1st Jan 2008 ( a leap year) this gives:

    (6+8+8/4+1+0)/7=17/7--> 2 times with remainder 3 --->Wednesday

    but 1st Jan 2008 was a Tuesday!

    The formula I had derived uses Saturday as 0 and 2000-2099 as 0, but you still need to subtract 1 if the date is in a Jan or Feb of a leap year.

    Excellent tutorial with great explanations of the process, but misses this caveat.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more