2 minute job - write a formula to extract the data if it falls between two dates

Hi, In my opinion, that only can be done with vba code / macro approach.. Please test and review the attached file I've made from your sample file at: [login to view URL] 1. Set the date Period in the yellow 2. Click the "Show" button 3. The results will be shown in the "Shows Open" tab, you can use the auto filter (dropdown button in cell A1) to show only dates you want to see. This workbook is using "macro / vba code" to do the process. Make sure you click enable macro/content the first time you open this file in your pc to activate the macro. Let me know your comments, Daniel

Hi I have clearly gone through your project. And i have Perfectly understood what requirements has to be completed in this project. I'm Very Confident of doing project like these. So I'm only asking for the opportunity, if you give me the opportunity I'll complete the project with my very best. Thank You.

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

A proposal has not yet been provided

Hello, I can do it for 10 GBP Best Regards Jan

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

Hi there, Thank you for reading this. Have you tried to filter the columns? You can see the result at a glance. Regards, Florin

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I have a working mockup for you, I cand send it immediately if you open a chat. Regards

Dear Employer! I've read the entire description. I have sound knowledge of data entry, web search and data mining jobs. I am a professional user of Office (Word, Excel, Power Point) and other programs. I have 6 years of experience of these kind of work. Please give me an opportunity and I will prove that I am a good freelancer.

I have the expertise in Excel and can do this right now for you., accurately as you would like to see it.

Hi I know what you need. I can write a simple macro which will extract data for certain dates that you want to look for. Its not a 2 minute job but I am sure it will worth introducing my skills to you and that's the reason I have made the most challenging bid. Please check my reviews. I am sure you will be my next satisfied client. Hope to hear from you soon. Thanks

Hi there, I am a Microsoft Certified Excel/Word Expert and a Preferred Freelancer and i can help with your quote. I have been involved in many VBA related projects for a wide variety of businesses. From medical reports developed in Word to any type of Excel Data Analysis, Excel Data scrapping, you name it, I am the developer for your job. Check this https://www.freelancer.com/u/mexmarius.html profile for reference work. PM me if interested.

Hi, should be can solve using Pivot Table. Please send me a message so I can show you the example. I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm looking forward to serve you, on your available task.

****100% work grantee. Fast delivery** Hi there, It is my pleasure to introduce myself. I'm ZahidBabu I have been doing Data entry, PDF to Word, Excel Copy Paste, PowerPoint Presentation, Photo Editing/Background Changing, Color Mangaemat, Logo creat and all kinds of work on computer last 7 years. I have seen your project. I'm Interested to do your project. If u consider and hire me, I am confident I will be able to do the job as you require. Look forward to hear from you. Best Regards Zahidbabu

Dear Hiring Manager, We can do this JOB efficiently and effectively Have a great day to you, I am interested to do this job, I have over 15 years experience in the field of web research, web scraping, data-entry in excel and as admin/ virtual assistant. And I am a computer and web savvy, my goals are to make the employer/ customer happy and give better quality of work and I am ready to dedicate time for this project. Thank you Kind regards Heric. P. Note: I am quick, detail oriented and have expert team members with me to do this job and have high speed internet connection and I look forward to hearing from you to start this job soon. Thanks

Because of my reputation I can actually offer you a discount even with the price I bid in order to start getting my rank better. I hope this sounds interesting

I have very good knowledge of excel. you may contact with me regarding the project.

IT IS DONE ! (at least the part you uploaded). I can give it to you right away to test it ! To make it for a bigger file takes only 5 min. I have the "know how". Should you accept my bid, you'll have good results within minutes. Please ad details and/or upload or send the file(s) with your detailed requirements.

Dear Client, Greetings! Please be informed that I am interested with your project and may I have an honor to propose to this aforesaid project posted. In this connection, I am looking forward hearing from you with regards to my proposal. Thank you and more power! Sincerely yours,

Hello sir, I am ready to take the project. I went through your project description and got enough expertise to handle and finish your project within in budget and within deadline. Thanks & Regards, Fayjur Rahman

Hi, my name is Juan Pablo Carreras. I am proficient in excel and I have been using it for over twenty years. I am capable of giving you the needed formula. I have checked your file, and tryed something out that worked. Basically it would need for you to write the dates that you want to evaluate, and it would tell you in a column at the right of the list, which shows are available. That way, you would only need to change the dates you want to evaluate.