Find Jobs
Hire Freelancers

Need quick formula for Microsoft Excel

$15-25 USD / hour

Closed
Posted over 1 year ago

$15-25 USD / hour

I'm using both Word and Excel to create a Microsoft Word Mail Merge. The goal is to take today's date (it'd be ideal if it would self-update in the formula, if not it would be ok if I just need to change it each time I do a mail merge), subtract 10 years from it, add "Original Date" or [B1], and produce a result in the formula field formatted in years, months, days, showing how many days until expiration. The formula field would show how many days from today until expiration. Items expire 10 years after original date. I need an Excel formula, but it has to be tested such that when I merge that field into a Word doc, it will display as I want it to. One of the Excel fields is the original date of an item. For the formula, we'll call it "Original Date", or if I can just use the excel field the date is in, [B1] or whatever the field is. To simplify, it'd be ok to use 30 day months and 360 day years, though if possible I'd rather use the correct number of days in each month. Example: "Original Date" or [B1] = 2/14/2012 Today is 12/4/2022. Minus 10 years = 12/4/2012. Add [B1], or an answer of 2/14/12 (which is equal to 2 months, 8 days , 62 days, using the correct numbers of 31 days in December, 30 in January) (or rounding to 30 days months if necessary, it would be the 2 months, 7 days, or 61 days because the 31st of January would not be counted). I probably made that sound way more complicated than it is. I'll try to summarize with an example: My original date field in excel is [B1] (actually column B). Today's date is D. (D - 10 years) + B1 is the result I need. I'd prefer that result use the actual number of days in each month, which I guess could only be accomplished if Excel lets you perform the function of subtracting one date from another. Otherwise, use 30 days in a month, 360 days in a year. Use exactly 10 years for the 10 year function, so 3650 if it has to be converted to days. To re-iterate: I need an Excel formula that will take one date field, subtract 10 years or 3650 days, add another date field, and produce a result ideally formatted in Years, months, days (ie: 1 year, 3 months, 2 days). Another way to achieve this would be to take the original date [B1], add 10 year or 3650 days, and subtract the result from today's date. Either syntax should give the same result. I'll pay the first person to send me a message with a working formula. So if you see a bunch of other people have already sent me messages, I probably already have the answer but just have not received and tried it yet. Thanks in advance!! Lou
Project ID: 35414121

About the project

24 proposals
Remote project
Active 1 yr 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
24 freelancers are bidding on average $21 USD/hour for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion.. Thank you Sandeep
$20 USD in 40 days
4.9 (580 reviews)
8.5
8.5
User Avatar
SIR", I am EXCEL ALL FORMULAS Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar
$20 USD in 40 days
4.9 (247 reviews)
7.0
7.0
User Avatar
I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
$20 USD in 40 days
4.8 (163 reviews)
5.8
5.8
User Avatar
Hello, I can do the date formula in excel I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.
$20 USD in 40 days
4.9 (18 reviews)
4.5
4.5
User Avatar
Hey! I have vast experience in Data Entry, Microsoft Office, Excel, Visual Basic and Data Processing, and I am confident that I can produce quality content for you that will be of interest to your readers. I am available for a full-time writing position, and I am happy to work on a freelance basis if that is what you prefer. I look forward to hearing from you soon! Thank you for your time. Thank you - Carolyne
$50 USD in 22 days
5.0 (1 review)
3.6
3.6
User Avatar
I can deliver the job you want immediately. There are 3 different ways I can make the date event you want. Contact me.
$15 USD in 15 days
5.0 (5 reviews)
2.9
2.9
User Avatar
Data entry operator and an expert typist as well. If you assign me this project I'll definitely try my best to do it on time and will not make you upset. My typing speed is excellent and with 100% of accuracy. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thank you!
$15 USD in 40 days
4.0 (4 reviews)
3.0
3.0
User Avatar
Hi, How are you? Upon reading brief details I believe its a doable job I have great experience doing projects with Excel, Data Processing, Data Entry, Visual Basic and Microsoft Office. I am confident about getting this done. While I believe we need to have detailed discussion about it. I work as per Eastern time daily so that would be good for us to catch up on this job, Lets discuss this further and get started for you as soon as possible. Thanks! Shamshad
$25 USD in 24 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi , I am a professional in excel. I would like to share some of my knowledge and experience with your company. I can show you how to make your data more valuable and create reports to help you make better decisions. Please reply to me if you are interested in this offer. Thanks, {Avi Gupta}
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am honest data entry operator I have an ability to manage every situation i have an experience to complete my task
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Yes i can complete this project because i hav knowledge about ms office, data processing and excel thanks .
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hope you are doing well I am work harder and ambitious dedicated. Always drive my excel in to your dream work. Kindly consider giving me opportunity.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
My job is analysis manager with a long experience, can finish the data in 1 day with hight quality. Kindly contact me to agree on the data type and deadline and will finish the peoject asap.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can do the date formula in excel I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.
$15 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, My name is Mohit yadav. I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 1+ years of experiences in this field that makes me confident to apply in this project. My typing speed is one of my great assets for your project. I have been playing with MS Word and Excel for more than 1 years and I understand every inch of this software. I believe I will be an asset for your project. I have available time to start your project as soon as you hire me. I have a good market research skill that will assist you to do something innovative in your project.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
He, I am Muhammad Imran, I have done Masters in Computer Science. I have been working outside this platform with many clients all over the world, now I am here to provide my services to clients of this platform. I am applying this job as I think this is most suitable work. I am looking according to my skill. Data Entry Copy Past Lead Generation I am full time freelancer with fulfilling the commitment with no excuse, I have a team working and believe in long team client relationship.
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello there! I have MS office skills to eligible for your project. I can do tbis project for minimum pay with good effort. Thank you...
$16 USD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir I'm moin devgadh wala I'm cirtificatyfit Exal master in Andvance 100% sure work in challenge day your work get the job freelanceer
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi my name is Natasha Zulkifli and Im from Malaysia. I am writing in response to your advertisement for a quick formula for Microsoft Excel. Based on the skill required, I am sure that I am a suitable match for the job. Thank you in advance for your time and consideration. I look forward to Hiring from you soon Regards, Natasha
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can edit in pdf files Pdf to word or word to pdf or pdf to excel and excel to pdf . Data entry and data processing
$20 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ARGENTINA
Buenos Aires, Argentina
0.0
0
Member since Dec 4, 2022

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.