LinkBack URL
About LinkBacks
Hello. I have 2011 in A1, January in B1....I tried to create date(A1,B1,1) but it returned a Value error. Why?
Hello. I have 2011 in A1, January in B1....I tried to create date(A1,B1,1) but it returned a Value error. Why?
Try this formula
=DATE(A1,LOOKUP(B1,{"January","February","March","April","May","June","July","August","September","October","November","December"},{1,2,3,4,5,6,7,8,9,10,11,12}),1)
Sorry the last formula has an issue. Try this one!
=DATE(A1,MATCH(B1,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),C1)
Cell format is date
=(1&" "&B1&" "&A1)+0
Last edited by Ali Kırksekiz; 04-13-2015 at 03:10 AM.
Hi Amma,
As this is the same post for which you had just got an answer. So Kindly mark this thread as SOLVED.
http://www.excelforum.com/excel-gene...ing-weird.html
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks