one more for fun
=INT(DAY(A1)/7)+1&CHOOSE(INT(DAY(A1)/7)+1,"st","nd","rd","th","th")&TEXT(A1," dddd")
good luck
EDIT - I suppose fun should somehow equate to working, how about a revised formula of
=INT(DAY(A1)/7.5)+1&CHOOSE(INT(DAY(A1)/7.5)+1,"st","nd","rd","th","th")&TEXT(A1," dddd")
FINAL EDIT ? to you format
=INT(DAY(A1)/7.5)+1&"-"&WEEKDAY(A1,2)
[ This Message was edited by: IML on 2002-05-07 10:49 ]
[ This Message was edited by: iml on 2002-05-07 11:00 ]
Like this thread? Share it with others