I have a number of rows of data, all of which has a date in one cell in format of dd/m/yy. In a subsequent cell i am running a mid function to determine the month number. However, the format of the date seems to be a number i.e. 40909 rather than 01/1/12, and therefore my mid function is pulling out 9 rather than 1. I've tried everything to reformat the date cell but it makes no difference
If you already check the format, then pls upload a small sample workbook to show us the problem and to work on this.
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.
Book3.xlsx
Here you go
In col D and E enter =C2 and format as "ddd" and "mmm" respectively
Try
=IF(MONTH(C2)=1,"Jan",IF(MONTH(C2)=2,"Feb",IF(MONTH(C2)=3,"Mar","Apr")))
You can not use LEFT -MID & RIGHT functions for dates!
Oror
=text(c2,"ddd")- Also read http://www.cpearson.com/excel/datetime.htm#AddingDates= text(c2,"mmm")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks