I am looking to extract the month from a date using the mid function. i have 450000 rows of data and want to add a column with month as a data point for easier pivot manipulation. however - getting the following:
example - (source cell: C2) 2018-06-10 17:16, (destination cell formula) =MID(C2,6,2), (destination cell results) .7
Cant figure it out - please help.
If you really are using REAL dates (and not text looking like dates - you can test with =isnumber(cell-ref)...FALSE indicates text date), then...
What you need to understand about dates and times in excel is…
a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Sun 21 Apr 2019) is actually 43576
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
So =MID(TODAY(),3,2) = 57
To get just the month number...
=MONTH(TODAY())
= 4
To get the month name
=TEXT(today(),"mmm")
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks