Need to export date data in Julian calendar instead of Gregorian calendar
23 Jul 2014
To export date data in Julian Calendar instead of Gregorian calendar,
- Collect the date data as normal.
- Export the file.
- Open the CSV file in Excel.
- Add a column next to the Date Trait column.
- Copy this formula into first 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 value has been modified for your file, copy the formula to all the cells to be converted. This gives you a 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 Excel sheet. You can hide the columns you don't need.
- Copy the columns to a new Excel sheet.
- Save the Excel sheet as a CSV file.
Range |
Row |
Julian Flower |
---|---|---|
1 |
1 |
160 |
5 |
1 |
161 |
5 |
2 |
162 |
6 |
1 |
162 |
This new CSV file contains Julian dates for the collected date traits.