I need a formula that tells me the day of the year for a date. For example:

06/23/2008 = 175

With the date in cell A1: =A1-DATE(YEAR(A1),1,0)

"Byron720" wrote:

> I need a formula that tells me the day of the year for a date. For example:
>
> 06/23/2008 = 175

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.
--
Kevin Backmann


"Byron720" wrote:

> I need a formula that tells me the day of the year for a date. For example:
>
> 06/23/2008 = 175