Question: how to subtract julian dates in excel?
Answer: 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 (&).