G gary Sep 8, 2004 #1 How can I convert a date in this format (mm-dd-yyyy) to a Julian-date (i.e., YYYYDDD)? For example: 09-13-2003 to 2003256
How can I convert a date in this format (mm-dd-yyyy) to a Julian-date (i.e., YYYYDDD)? For example: 09-13-2003 to 2003256
R Ron Rosenfeld Sep 8, 2004 #3 How can I convert a date in this format (mm-dd-yyyy) to a Julian-date (i.e., YYYYDDD)? For example: 09-13-2003 to 2003256 Click to expand... Here's one way, with the date in A1: =TEXT(A1,"yyyy")*1000+A1-DATE(YEAR(A1),1,0) Format the cell as General or as Number with 0 decimal places. --ron
How can I convert a date in this format (mm-dd-yyyy) to a Julian-date (i.e., YYYYDDD)? For example: 09-13-2003 to 2003256 Click to expand... Here's one way, with the date in A1: =TEXT(A1,"yyyy")*1000+A1-DATE(YEAR(A1),1,0) Format the cell as General or as Number with 0 decimal places. --ron
