0

How to calculate the fourth column based on the first three columns in Excel?

Date cell to Julian day

for example:

year  month   day  **Julian day**
2000    1       1      1
2000    1       2      2
2000    1       3      3
....    .       .      .
....    .       .      .
2000     12     30     365
2000     12     31     366
2001     1       1      1
2001     1       2      2
2001     1       3      3
....     .       .      .
....     .       .      .
2001     12      30     364
2001     12      31     365
2

You can use this formula: =DATE(A2,B2,C2)-DATE(A2,1,0)

enter image description here

enter image description here

  • Thank you very much – ali Aug 26 at 8:44
  • Nice one @Lee ☺ – Rajesh S Aug 26 at 9:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.