Hello,
If Iunderstand you correctly:
=IF(A1<99,"1st",IF(A17574,"Older",ROUNDUP((A1-14)/84,0)&MID
("thstndrdth",MIN(9,2*RIGHT(ROUNDUP((A1-14)/84,0))*(MOD(ROUNDUP
((A1-14)/84,0)-11,100)2)+1),2)))
And if this is correct, the credit for the ordinal part belongs to
Rick Rothstein:
http://groups.google.de/group/micros...70e52 ba21036
Regards,
Bernd