Hello All
I have below attachment
when I enter a text in cell H automatically the today date appears (by vba code) on Cell E Full Day format
Cell D Year Format
Cell C Month Format
Cell B Day Format
but when I put the mouse curser on D,C & B format i see full day on formula bar
Is there a solution to see only year on formula bar for cell D
&
to see only month on formula bar for cell C
&
to see only day on formula bar for cell D
The below code is change the date format but what I need exactly is to extract part of the date either year, month or day
Thank youPlease Login or Register to view this content.
123.JPG
Bookmarks