ExcelBanter - How can I use day of year dates in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I use day of year dates in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/40934-how-can-i-use-day-year-dates-excel.html)

jbradford721

How can I use day of year dates in Excel?

I have data in Excel that has one column with the year (eg. 2005) and another
column with day of year (eg. 365 for Dec. 31). I would like to convert this
to a date format that Excel can use for calculations, graphing, etc.

StinkeyPete

See if this works for you:

A1 = Year
B1 = Day

=DATE(A1,1,B1)

"jbradford721" wrote:

I have data in Excel that has one column with the year (eg. 2005) and another
column with day of year (eg. 365 for Dec. 31). I would like to convert this
to a date format that Excel can use for calculations, graphing, etc.

jbradford721

StinkeyPete;
Thanks much! This seems to be working.
jbradford721

"StinkeyPete" wrote:

See if this works for you:

A1 = Year
B1 = Day

=DATE(A1,1,B1)

"jbradford721" wrote:

I have data in Excel that has one column with the year (eg. 2005) and another
column with day of year (eg. 365 for Dec. 31). I would like to convert this
to a date format that Excel can use for calculations, graphing, etc.

All times are GMT +1. The time now is 05:24 AM.