Find Jobs
Hire Freelancers

Excel Formula Help

$10-30 USD

Completato
Pubblicato più di 5 anni fa

$10-30 USD

Pagato al completamento
Need a formula to display yesterday's date in this format: date_shipped:2018-8-31 date_shipped:",CONCATENATE(YEAR(TODAY()),"-",MONTH(TODAY()),"-",DAY(TODAY()-1))," I use this Excel formula to get yesterday's date for our tracking numbers. I need to show that the date shipped was Yesterday. For ex. Today is Aug 1, 2018. The formula needs to show July 31st, 2018. Tomorrow, Aug 2nd, the formula needs to show Aug 1st. Current formula is above. The issue occurs on the first of the month, where the Month being displayed is for the current month, when it needs to be for the previous month.
Rif. progetto: 17487578

Info sul progetto

16 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hi, This is fairly straight forward question. I can provide quick solution for this. Looking forward to work on the project. -Chandra
$15 USD in 0 giorno
5,0 (836 valutazioni)
7,9
7,9
16 freelance hanno fatto un'offerta media di $24 USD
Avatar dell'utente
Hello! i can help you with the formula now. it will not take me longer than 1 hour. You will not be dissapointed, I have a big 36% rehire rate. thank you!
$25 USD in 1 giorno
5,0 (220 valutazioni)
7,5
7,5
Avatar dell'utente
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$30 USD in 0 giorno
5,0 (214 valutazioni)
6,8
6,8
Avatar dell'utente
Hi, As you want help in formula to display yesterday's date in specific format. I will help you in this. Please share your data sheet so that I can do this task for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Peter
$30 USD in 1 giorno
5,0 (70 valutazioni)
5,7
5,7
Avatar dell'utente
Sir, I have gone through your project description and am looking to provide my service for excel help. For more than 2 years I’ve worked in this field.
$30 USD in 1 giorno
4,9 (5 valutazioni)
3,6
3,6
Avatar dell'utente
Hello, I have experience in creating macros and entering data in Excel for more than 7 years. I assure you an excellent job, I will not disappoint you. If you want to work with me, do not hesitate to contact me.
$17 USD in 1 giorno
5,0 (3 valutazioni)
2,4
2,4
Avatar dell'utente
A very simple task, the trick is to subtract 1 day from today date, then display it. I will give you the formula right away
$20 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hey, I'm trying to build reputation, You gonna be delighted not just satisfied. Experience : Advanced experience in Excel, since i used it back in school (computer science) & working in banks. Of course in banks you can't afford errors (any kind), So I grantee you your spreadsheet will be done Accurately , Free from error, reliable for future quires or reports. I've been working with all excel functions familiar with all of them. I will do this job easily.
$15 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Gulf experienced management professional with 18+ years of progressive experience in accounting, financial and general management within diversified industries. Competency in various financial accounting fields including but not limited to general accounting, AR / AP, general ledger, financial controlling, costing, cash management, maintenance of book of accounts, budgeting, auditing, reporting, and client relations. Strategic thinker with track record of handling finance and accounting department independently with systematic work approach to drive efficiency and financial productivity. Committed, honest and results driven team leader with excellent communication, analytical, coordination, planning, organizational, problem solving, decision making and time management skills. Well versed in ERP accounting software. Diligent professional with experience across MIS Management, Administration & Operations. Gained extensive experience in MIS reports on various scenarios. Database management using Advance Excel - Macros, Advance Filter, Functions & Formulas, Pivot table, Goal Seek, Importing & exporting data, validations, Develop Excel Templates
$25 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hello Sir, I'm Helal and have seen the project summary. You want a logo design for your branding product. I have a vast experience on graphics Design about 5 years. I can make sure you that the design will must very unique, nice and eye catching to the viewers. I'll give you unlimited revision at your demand. And Already I have finished some Logo design. you may visit my profile and may check the feedback. Thank You so much.
$15 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
Bridgeville, United States
5,0
28
Metodo di pagamento verificato
Membro dal ott 21, 2015

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.