Excel MJD formula

[Ripley]

I "proudly" present my latest XL creation (made with Excel 2003).

It's just an MJD conversion formula I made with the help of Wikipedia and various cross-checks websites and Orbiter's own "date.exe" utility.

XL sheet is nothing more than a draft and follows Wikipedia's page calculations and my own "findings".

Nevertheless, there is a "one-cell" formula that sums all the bits and pieces up, and it only needs a date in a cell and an (optional) hour in another.
If you need it, use it.

This will probably be my first and last post in the Math sub-forum, where I don't really belong...I just like fiddling with XL.

Algorithm is here
http://en.wikipedia.org/wiki/Julian_day#Calculation
More infos
http://www.ehow.com/how_5121943_calculate-mjd.html


Download MJD dates in Excel