Date functions
 

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?

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

where cell A1 holds the day of the year

"Kirk P." wrote in message
...
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?

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Kirk P." wrote in message
...
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?