Refering to the post in general question
Does anyone know how to do it in excel?
In cell A1, if text within this cell is "Daily", then the cell B1 will show
the date in this format "18-Jan". If cell A1, if text within this cell is
"Monthly", then teh cell B1 will show the date in this format "Jan-07"
Does anyone have any suggestion?

Thank you for any suggestion
Eric