My mistake, I forgot to mention that I need a cell formula,
not a vba solution.

Since this is a programming newsgroup, it will normally provide VBA
solutions. If you are seeking formula solutions in the future, the
microsoft.public.excel.worksheet.functions would be a better newsgroup to
post to for them.

--
Rick (MVP - Excel)