Hi

Try
=IF(COUNT(C1:D1),
IF(C1,TEXT(DATE(LEFT(C1,4),MID(C1,5,2),1),"mmm-yyyy"),
TEXT(DATE(LEFT(D1,4),MID(D1,5,2),1),"mmm-yyyy")),"")

All the above should be on one line
--
Regards
Roger Govier

AskExcel wrote:
Dear Forum,
I have a scenario where I need to compare 2 date cells. When cell1 empty
then take cell2 and format the date month-yyyy in cell3. When cell1 not empty
then take cell1 date and format the date month-yyyy in cell3.

i need advise how can i do that and create macro to automate the change.
example
c d e
20100220 feb-2010

c d e
20100521 20100220 may-2010