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

Range

Row

flower

Julian Flower

1

1

6/9/2014

160

5

1

6/10/2014

161

5

2

6/11/2014

162

6

1

6/11/2014

162

 

 

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

 

 

Range

Row

Julian Flower

1

1

160

5

1

161

5

2

162

6

1

162

 

 

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