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
 
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
Click to expand...
 

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

Similar Threads

Change satellite julian date format YYYYDDDHHMMSS to excel date ti 1
Number of the day of the year 3
Julian Date Display in Query 3
Date Formating 5
format 1 digit year 1
Convert julian date 14
Formula to show when the julian date changes 1
How to Convert a Julian Date to Calendar Date 2

Top