Three Digit Julian Date

G

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
 
B

barry houdini

George;495231 said:
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
 
G

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
 
F

Fred Smith

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

Regards,
Fred
 
G

George

Thanks - That works....

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

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top