ExcelBanter - Three Digit Julian Date

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

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

- - Three Digit Julian Date (https://www.excelbanter.com/excel-discussion-misc-queries/243178-three-digit-julian-date.html)

George

Three Digit Julian Date

I am looking for a three digit Julian date formula for my spreadsheet. I have
found formula's that display the julian date with the two and or four digit
year included but I just need the three digit for the day of the year.

Thanks

All times are GMT +1. The time now is 07:15 AM.