Date functions

[Guest]

Our database represents dates by giving the day number within a year. For
example, day number 1 is January 1, and day number 365 is December 31. Is
there a function to convert day number to mmm-dd?

 

[N Harkawat]

=TEXT(DATE(2005,1,A1),"mmm-dd")

where cell A1 holds the day of the year

 

[JulieD]

Hi Kirk

how does this work with leap years????

anyway how about
=TEXT(DATEVALUE("31/12/04")+A1,"mmm-dd")
where your imported number is in A1
note this will format the date to a text rather than a number
if you want a number use
=DATEVALUE("31/12/04")+A1
and then use format / cells - to format the date as you want.