Hi all,
This is my second post, i hope your help can solve my problem as my previous one.
So the problem is, i want to automatically extract each of the date, month and year from a previous inputted date format to several different cells.
For Example
in cell A1 i will input 29-march-2013, then i want each of the cells in B1, C1 and D1 automatically inputted by change to each of date, month and year E.g: B1= 29, C1=March or 3 D1=2013.
Many thanks for your kind assistance!
=day(a1)
=month(a1)
=year(a1)
If you want to extract the actual values for each day, month year, then mama's suggestion will work for you.
If you just want to display the day number, month number etc, you could just reference the celkl with the date in it, and then format to show dd, mmmm and yyyy
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Originally Posted by Teethless mama
"mama knows best"...its true!!
Many thanks y'all!!
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks