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