I am trying to find a solution for my issue,
I created a micro that insert date column and fill it, now I need to make the date=activatesheet name but I couldn’t

my code is below


the result coming as “Aprils” instead of the date.

please let me know where is my mistake or the alternative solution.
appreciate the support.