Three Digit Julian Date

  • Thread starter Thread starter George
  • Start date Start 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
 
As of now I don't have a date in cell A1 - is there a formula
that just looks at the computer clock ?

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

Regards,
Fred
 
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
Click to expand...
 
Back
Top