Julian day in formula

Topic

New Reply

I have this formula:

=AVERAGE(OFFSET($H$1,MATCH(TODAY(),$A:$A,FALSE)-30,0,5,1))

The ’30’ represents 30 days in this formula.

I want to replace this ’30’ number with a dynamic calculation that resolves to the Julian DAY number. So for today (July 29) that number would be 211. Tomorrow, it would be 212.

I’ve been reading help on Julian dates in Excel but can’t seem to find something that does this in a simple manner.

Reply | Quote

Replies

I’ve been reading help on Julian dates in Excel but can’t seem to find something that does this in a simple manner.

Perhaps look at Ordinal date or days rather than Julian, but you won’t find something particularly simple.
The Wikipedia article is as good as any!

BATcher

Plethora means a lot to me.

Reply | Quote

Lots of people have asked this question and similar (per Mr. Google). I finally stumbled on a concise answer:

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

Reply | Quote