Three Digit Julian Date

[George]

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

 

[barry houdini]

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

Thanks

So today, 18th September 2009, would be 262?

If you have a date in a1 this formula will give the "day of the year"

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

format as general, or if you want leading zeroes custom format as 00

 

[George]

As of now I don't have a date in cell A1 - is there a formula
that just looks at the computer clock ?

Thanks

 

[Fred Smith]

Certainly. Either enter Today() into A1, or replace A1 with Today, as in:
=Today()-DATE(YEAR(Today()),1,0)

Regards,
Fred

 

[George]

Thanks - That works....

Certainly. Either enter Today() into A1, or replace A1 with Today, as in:
=Today()-DATE(YEAR(Today()),1,0)

Regards,
Fred

 

[Fred Smith]

Glad we could help. Thanks for the feedback.

Fred.