Hello,

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

Aprils=activatsheet.name(left,7)

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

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