I need a formula that tells me the day of the year for a date. For example: 06/23/2008 = 175
B Byron720 Jun 23, 2008 #1 I need a formula that tells me the day of the year for a date. For example: 06/23/2008 = 175
K Kevin B Jun 23, 2008 #3 The following function will produce the Julian date you requested. Substitute the cell address A1 with the cell that contains the date: =A1-DATE(2008,1,0) You will probably have to format the cell for a number format of 0 decimals as it will pick up the data format from the date cell.
The following function will produce the Julian date you requested. Substitute the cell address A1 with the cell that contains the date: =A1-DATE(2008,1,0) You will probably have to format the cell for a number format of 0 decimals as it will pick up the data format from the date cell.
