Excel Formula Help
$10-30 USD
Betalt ved levering
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.
Projekt ID: #17487578
Om projektet
Tildelt til:
Hi, This is fairly straight forward question. I can provide quick solution for this. Looking forward to work on the project. -Chandra
16 freelancere byder i gennemsnit $24 timen for dette job
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!
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
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,dat Flere
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.
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.
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
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 Flere
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 includi Flere
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 Flere