Hello,
I'm trying to figure out how to convert julian dates to moon phases in excel.
I already converted normal dates into julian dates in excel using the formula: =TEXT(A4,"yyyy")&TEXT((A4-DATEVALUE("1/1/"&TEXT(A4,"yy"))+1),"000")
Now I need to figure out how to use the julian dates and find their moon phases.
Thanks
I'm trying to figure out how to convert julian dates to moon phases in excel.
I already converted normal dates into julian dates in excel using the formula: =TEXT(A4,"yyyy")&TEXT((A4-DATEVALUE("1/1/"&TEXT(A4,"yy"))+1),"000")
Now I need to figure out how to use the julian dates and find their moon phases.
Thanks