Extract Year, Month, Day from date

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

Please Login or Register  to view this content.

Thank you

Attachment 453146

attached file

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-prog...from-date.html

Thread Closed.