excel Help

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the projects, i do everything, that's why i only take what interests me and i can do it effectively. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards

Greetings! I have worked out the formula for you - If 20130203 is in cell B3, use the following formula in cell C3. =TEXT(DATE(LEFT(B3,4)+1,MID(B3,5,2),RIGHT(B3,2))-2,"yyyymmdd") Copy the formula to rest of the rows in Col C. This should work! Have a Great Day! Srinivasan

Hi There, I have read your details & I think I am the perfect one for your job. I have completed several project like this. Quality & accuracy is my commitment. I am ready to show you free sample. Please message me back. Regard’s Razia Sultana

Hello, I have written an excel formula according to your requirements. Let’s discuss if you’re interested. Best regards, Duong

$ 15 Only ------ In just 30 Minutes ------ Excel Data Management, VBA Macro Coding and Formula Generation Expert

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for your project. Please send me a message and we can move forward with your project.

it's a simple formula, please reply, thank you.

Hi, I can do this dates calaculations for you using the formulas. I am a Microsoft Certified Excel professional. Thanks

Hello, I am Luis and I will be glad to assist you with your project. I know Excel and I can assist you with your task. Please contact me by chat then we could discuss further details about your project. Kind regards, Luis Romero

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on freelancer.com and I do not bid on projects which I am not sure. I will not disappoint you and I will do my best for give you a perfect solution. If I have an opportunity to work with you, That's my pleasure. No milestones required in advance, please pay me once the job is 100% complete. Also, before you consider awarding me the project, I can provide you with some sample files via your requirements. Please message me, so we can discuss here as I may have some questions. Thank you. Marko R.

Hi, I can write the needed formulas to fill the next column with the needed date according with the date from the first column. Best regards, Florin Enache

Hi, if you send me your Excel file I can help you better because your formula is depend on if the first column data type is Text string or date value, if its text string then you need to use LEFT RIGHT and MID functions combined with DATEVALUE function to convert it into the date, then add one year into it and then converting it back to text string, please send me message to discuss more

Hi Good Day! A serious freelancer here. I have a Formula for that. Please message me and I can make it in less than an hour. I can help you to complete this project now. Please share to me your file. Please consider my bid, I really need this work for my family. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. I am also a Project Management Analyst for 8 years in Accenture which given me the knowledge of creating quality dashboards and financial reports for our Clients. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!

Hi, You want to change the date in Col 2 like the one you have Col 3 of your example. I can give that formula to do this work for you. It is simple Ping me. Regards Reuben

Hi, sir. Thank you for your posting. :) I am very interesting in your project. I am excel and excel vba expert. I have rich experience of making excel project using vba. For example I have made finance excel project. I have been working as a excel expert for 7 years. If you want me, please ping me. I will do my best for you. Best regards. :)

Hello. I can do this using 2 pivot columns, or making a combined formula. This should take an hour or less. Thank you.

A Data Scientist with experience in SPSS, Advanced Excel, R programming, R Shiny, R studio and anything related to data science and python Master in Engineering, Electrical and Electronic Engineer, who is dynamic, reliable, resourceful, committed and organized with enthusiastic approach to succeed with a pleasant attitude. Possessing excellent analytical skill and good research background. HIRE ME TO GET THIS DONE ASAP

HI, We should be able to do this with built in functions. But if not because of formatting then a small vba function could be written to solve the problem. I've worked with excel for over twenty years so will be able to help. Regards Steve

FREE ! Solution ! =DATE(CNUM( MID(B2,1,4) )+1, CNUM( MID(B2,5,2) ), CNUM( MID(B2,7,2) )) -2 If B2=20140304 MID(B2,1,4) = “2014” MID(B2,5,2)= “03” MID(B2,7,2)=“04” CNUM(...) makes numbers from text. DATE(year,month,day) is a date, so DATE(year+1, month, day) -2 is your solution. Final formula : = DATE(CNUM( MID(B2,1,4) )+1, CNUM( MID(B2,5,2) ), CNUM( MID(B2,7,2) )) -2 I’m doing this from my iPhone (and I’m used to Excel in French) without Excel but I’m sure it works. FREE ! Contact me for harder problems, I’m fast and efficient.