1
Vote

Bug in excel:julian-to-gregorian

description

Hi,

The method excel:julian-to-gregorian in spreadsheet-ml-support.xqy is developed from an algorithm in the webpage http://quasar.as.utexas.edu/BillInfo/JulianDatesG.html

However, there is an issue in the line

let $year := if($E <=2) then $C - 4715 else $C - 4716

It should be

let $year := if($month <=2) then $C - 4715 else $C - 4716

Please check.

comments