Find Jobs
Hire Freelancers

.vbs script

$10-30 USD

Closed
Posted over 6 years ago

$10-30 USD

Paid on delivery
I need to create a .vbs script that does the following. I need the script to read a .xls file with start and end dates from an excel spreadsheet. In addition, if there is no excel spreadsheet, I need to automatically process the following dates. Get the first day of the previous month Get the last day of the previous month Add a day to the first day of the previous month. Just the function to handle. Get the first, second and third and fourth week of the previous month.
Project ID: 15992924

About the project

12 proposals
Remote project
Active 6 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
12 freelancers are bidding on average $31 USD for this job
User Avatar
Greeting, I have understood your .vbs script task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Software Architecture, Visual Basic
$50 USD in 1 day
4.9 (422 reviews)
8.2
8.2
User Avatar
Hi there, I can write the VBA script quickly. I'm an expert in Excel VBA with over 5+ years of experience. Ping me to discuss more. Thanks Aman
$30 USD in 1 day
4.9 (175 reviews)
6.5
6.5
User Avatar
Hey! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I would like to offer my services for this project. I will provide you a VB script in excel file which will fulfill your requirements. Best Sourabh
$25 USD in 1 day
5.0 (150 reviews)
6.1
6.1
User Avatar
Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing and analyzing any company variables. Experience on programming with VB in excel, creating any report using pivot tables and pivot charts, dashboards.
$30 USD in 0 day
4.9 (30 reviews)
4.9
4.9
User Avatar
Hi there, Greetings! I’m interested in the job and can start working right now to get it well done quickly. Feel free to contact me and discuss more details. Best Regards,
$35 USD in 2 days
4.9 (11 reviews)
3.7
3.7
User Avatar
Hello ! My experience with vbs is more than 10 years. Can you provide examples of xls files? Thank You. Regards, Alexei.
$20 USD in 5 days
5.0 (3 reviews)
2.2
2.2
User Avatar
Hello. Happy New Year! I have many experiences in excel vba, macro, xls file read more than 3 years.
$25 USD in 1 day
5.0 (2 reviews)
0.9
0.9
User Avatar
I have 25 years of experience developing programs, functions and even macros for Excel and before in Lotus 1-2-3. The work is very simple, since you only need 4 functions that when you provide a date in a cell it will return the required data. So you can use these functions in the spreadsheet that you want. I only have two questions, when you ask for the first, second, third and fourth week of the previous month, do you mean the number of the week? or start date of week?. For me it is the same. And, What happens if the month has 5 weeks as March 2018? Are you interested in having 5 weeks?, if the month had them. I would love to be able to do this project since the excel projects are my favorites. -------------- P.S. I was so interested in your project that I already developed it... This is the example of the Excel sheet: Date 05/02/2018 First Date 01/01/2018 Last Date 31/01/2018 Second Date 02/01/2018 Weeks 1, 2, 3, 4, 5 Date 06/03/2001 First Date 01/02/2001 Last Date 28/02/2001 Second Date 02/02/2001 Weeks 5, 6, 7, 8, 9 Date 06/03/2000 First Date 01/02/2000 Last Date 29/02/2000 Second Date 02/02/2000 Weeks 6, 7, 8, 9, 10 Date 06/12/2017 First Date 01/11/2017 Last Date 30/11/2017 Second Date 02/11/2017 Weeks 44, 45, 46, 47, 48 Date 30/01/2018 First Date 01/12/2017 Last Date 31/12/2017 Second Date 02/12/2017 Weeks 48, 49, 50, 51, 52, 53 Date 27/03/2015 First Date 01/02/2015 Last Date 28/02/2015 Second Date 02/02/2015 Weeks 6, 7, 8, 9
$19 USD in 0 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Irving, United States
5.0
3
Payment method verified
Member since Jan 22, 2006

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.