Need to export Date data in Julian Calendar instead of Gregorian Calendar

23 Jul 2014

Need to export Date data in Julian Calendar instead of Gregorian Calendar

Collect the Date trait as normal

Export the file

Open the CSV file in Excel

Add a column next to the Date Trait column

Copy this formula into 1st cell of new column:

=TEXT(C2,"")&TEXT((C2-DATEVALUE("1/1/"&TEXT(C2,"yy"))+1),"000")

In this example the column with the date in it is ‘C2’

Once the ‘C2’ part has been modified for your file, copy the formula to all the cells to be converted.

This will give you a the Julian date in the new column

Now select the columns that you want to save in a new sheet

(you could hide the columns that you don’t need)

Once the columns are selected copy them to a new sheet

Then save the sheet as csv

Now you have a csv file with Julian dates from collected date traits