Date functions

K

Kirk P.

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?
 
J

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.
 
Top