andyshrimpton
New Member
Hello all.
I have been trying the julian date code found in the code snippets section but do not understand what is going on. Link at botton of this post
UPDATE The code at the bottom of the page work fine it was user error entering the figures
I am trying to calculate the number of days between to dates for example from 1/1/2012 to 1/7/2014 which in excel is 912 days which allows for a leap year. The julian numbers are 2455928 and 2456840= 912 differance
http://www.nr.com/julian.html
There are many codes that can be used found on google but they use large numbers (7 figures during calculation)
Has anybody done this before and willing to share the code or explain how the code here works
http://www.picaxeforum.co.uk/showthread.php?t=8674
Regards
I have been trying the julian date code found in the code snippets section but do not understand what is going on. Link at botton of this post
UPDATE The code at the bottom of the page work fine it was user error entering the figures
I am trying to calculate the number of days between to dates for example from 1/1/2012 to 1/7/2014 which in excel is 912 days which allows for a leap year. The julian numbers are 2455928 and 2456840= 912 differance
http://www.nr.com/julian.html
There are many codes that can be used found on google but they use large numbers (7 figures during calculation)
Has anybody done this before and willing to share the code or explain how the code here works
http://www.picaxeforum.co.uk/showthread.php?t=8674
Regards
Last edited: