LinkBack URL
About LinkBacks
shannen 
I've search, search, search about date format but I can't figure out what is the exact code for it.
How I can determine the week of the date format in vba.
Example:
*Input:
Cell[A] -> 09/11/2013
*Output:
Cell[B] -> Wednesday
Cell[C] -> 'Sept-13
I've search, search, search about date format but I can't figure out what is the exact code for it.
How I can determine the week of the date format in vba.
Example:
*Input:
Cell[A] -> 09/11/2013
*Output:
Cell[B] -> Wednesday
Cell[C] -> 'Sept-13
Last edited by shannen; 09-11-2013 at 04:40 AM.
Why do you want to do this using VBA? You can do using quite simple formulas!!
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I see.Originally Posted by Fotis1991
I don't know much using formulas.
I solve already Cell[A] but Cell[B] quite hard. Can you give me some guidelines or site?
Thank you Fotis
*I want using VBA because I'll combine it with my code. So that it will process fast.
Last edited by shannen; 09-11-2013 at 03:17 AM.
In B1 try
=WEEKDAY(A1)
Format as dddd
In C1 use
=A1
Format as mmm-yyyy
Or
In A1 Cell
09/11/2013
In B1 Cell
Formula:
=TEXT(A1,"DDDD")
In C1 Cell
Formula:=TEXT(A1,"MMM-YY")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you guys =))
I already solve my problem. Thanks a lot.
I'll mark it solve now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks