how to subtract julian dates in excel?
Excel has no built-in function to convert a standard date to Julian date, but the figure illustrates how you can use the following formula to accomplish the task. This formula is really two formulas joined as a text string using the ampersand (&).