Find Jobs
Hire Freelancers

Google Sheets Query Function Filtering Between Two Dates

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
Goal: #1: Using "Report" Sheet when a user types in the Start Date and End Date of data they need, the query will search the "Returns" sheet and display all the rows that fall between those two dates. #2: On "Report" Sheet in Cell B5, total Column G (Price) *Returns sheet will have an infinite amount of rows
Project ID: 18646506

About the project

14 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi there, I have 5+ years of experience in spreadsheet applications and programming. I have prepared a demo video of what your filter would look like ( [login to view URL] ), I could deliver the task in 10 minutes. Would love to help with your project. Please feel free to contact me to discuss further details. Cheers, Samer
$15 USD in 0 day
5.0 (9 reviews)
3.8
3.8
14 freelancers are bidding on average $28 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$70 USD in 2 days
4.9 (366 reviews)
8.0
8.0
User Avatar
I have excellent command on Google Sheets and know how to write the formulas to filter data and find totals. I have completed complex projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JSON API in google sheets - Extract mails and attachments from gmail to google sheet and drive respectively - Twitter functionality like retweet, auto-tweet, and so on - Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization You can see the reviews of the same in my profile
$30 USD in 1 day
4.9 (104 reviews)
6.0
6.0
User Avatar
Hello I would be happy to help with your filtering issue. This would need a script inserted to the sheet so it listens out for the date range. Unfortunately this cant be done just by using conditional formatting, a script will be needed to do this automatically. I will be happy to implement this for you. I have over 10 years experience with excel/vba which Google sheets is based from. I look forward to working with you soon. Kind regards Steve
$30 USD in 1 day
5.0 (8 reviews)
4.0
4.0
User Avatar
Hello, I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Office. My typing speed is more than 50 words per minute. I believe my skills would be ideal for your project.I can dedicate 30 hours/week for your job, and my daily hours are negotiable. I’m very excited to offer my services for your job. Please feel free to contact me directly to discuss this position further. Thanks, Kadirul
$10 USD in 1 day
4.9 (6 reviews)
1.2
1.2
User Avatar
Hello I am a senior developer who can finish your project pefectly. I am ready to work for you. Best regards
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I may not be understanding from your description but it sounds like something I could do for you in under 30 minutes. Maybe under 5. Can we talk specifics? If this is as quick as I think, I'll do it for $15 so you keep me in mind for future Excel needs.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is what I do. I have created hundreds of google spreadsheets with complex formulas of exactly the type described. If you want any other functionality we can look into that as well. I'm just getting started on freelancer.com and I will work with you as much as needed to get this done right and to start off on the right foot. Thank you!
$23 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an very expert on Google sheet, I could do your jobs in minutes, help me to build my portfolio and I could help you with your sheets problem with lower fee.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Kalamazoo, United States
5.0
19
Payment method verified
Member since Aug 5, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.