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