Excel should support DAYOFYEAR(year,month,day) returns julian dat.

N

Neil

And the reverse function JULDATE. This is easier than writing the equation:
=DATE(2005,4,15)-DATE(2005,1,1)+1
 
J

Jason Morin

While complaining about lack of basic essential
functionality in Excel is OK, it should be accompanied by
some type of Excel-related question. Posts that simply
whine waste everyone's time. In addition to your
complaint, you could have asked "Is there a shorter
alternative to my formula?" Sure! A UDF!

Function Dayofyear(iYear As Long, _
iMonth As Long, iDay As Long) As Long
Dayofyear = DateSerial(iYear, iMonth, iDay) - _
DateSerial(iYear, 1, 1) + 1
End Function

HTH
Jason
Atlanta, GA
 

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

Month days over a time period 5
XIRR vs. IRR Function 11
converting julian day and year to a date? 1
Value of the first day of a year in a list 5
Extra help on Nth Day of month 1
Excel Formula for years and months 2
Excel Logical function 5
YEAR MONTH DAYS COUNTER 8

Top