dates

[Aaron]

Is there a formula that will give the day of the year a
certian date is. meaning 1/1/xx = the 1st day of the year

2/2/xx = 32

any ideas?

 

[Peo Sjoblom]

One way

=DATEDIF(A1,B1,"d")

 

[Daniel.M]

Hi Aaron,

If I understood you well, with a date in A1:

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

You can take a look at : http://www.cpearson.com/excel/jdates.htm

Regards,

Daniel M.