Ditutup

Need quick formula for Microsoft Excel

Job Description:

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

Kemahiran: Excel, Pemprosesan Data, Visual Basic, Pemasukan Data, Microsoft Office

Tentang Klien:
( 0 ulasan ) Buenos Aires, Argentina

ID Projek: #35414121

25 pekerja bebas membida secara purata $21/jam untuk pekerjaan ini

schoudhary1553

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 a Lagi

$20 USD / jam
(570 Ulasan)
8.5
AccountantArman

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 world Lagi

$20 USD / jam
(216 Ulasan)
6.8
merinsinha

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 Lagi

$20 USD / jam
(158 Ulasan)
5.8
iamhamzazaki

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 / jam
(16 Ulasan)
4.3
Jaweria101

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 a Lagi

$15 USD / jam
(3 Ulasan)
2.4
ersoyyusuf

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 / jam
(1 Ulasan)
1.4
mwikalicarolyne2

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 availa Lagi

$50 USD / jam
(0 Ulasan)
0.0
AITSoft

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 thi Lagi

$25 USD / jam
(0 Ulasan)
0.0
AviGupta12

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. Lagi

$20 USD / jam
(0 Ulasan)
0.0
Choubisaprasun

I am honest data entry operator I have an ability to manage every situation i have an experience to complete my task

$20 USD / jam
(0 Ulasan)
0.0
mritunjay420

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. Lagi

$20 USD / jam
(0 Ulasan)
0.0
khushikumari4292

Yes i can complete this project because i hav knowledge about ms office, data processing and excel thanks .

$20 USD / jam
(0 Ulasan)
0.0
bushramaniar7

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 / jam
(0 Ulasan)
0.0
OmarEnguebawy

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 / jam
(0 Ulasan)
0.0
sekhar8287

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 / jam
(0 Ulasan)
0.0
RAOJI1357

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 mak Lagi

$20 USD / jam
(0 Ulasan)
0.0
Sherdill76507967

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 a Lagi

$20 USD / jam
(0 Ulasan)
0.0
santhoshRs12345

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 / jam
(0 Ulasan)
0.0
Moin7284

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 / jam
(0 Ulasan)
0.0
anastasyah97

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 Lagi

$20 USD / jam
(0 Ulasan)
0.0