ExcelBanter - show date as day of the year

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - show date as day of the year (https://www.excelbanter.com/excel-worksheet-functions/152832-show-date-day-year.html)

Brad

show date as day of the year

i would like to show jan 1st is 1, or 8/2 is 214 ect

whats the function??

thanks
brad

Mike H

show date as day of the year

Try this

=A1-DATE(YEAR(A1),1,0)

date in A1 and format as general

Mike

"Brad" wrote:

i would like to show jan 1st is 1, or 8/2 is 214 ect

whats the function??

thanks
brad

Brad

show date as day of the year

Worked!!!!

thank you

"Mike H" wrote:

Try this

=A1-DATE(YEAR(A1),1,0)

date in A1 and format as general

Mike

"Brad" wrote:

i would like to show jan 1st is 1, or 8/2 is 214 ect

whats the function??

thanks
brad

All times are GMT +1. The time now is 04:46 AM.