I have an date column that is formatted as DD/MM/YYYY but I want to convert it to MM/DD/YYYY. Is there an excel formula to do this? I can’t find anything online

like
Posting as :
works at
You are currently posting as works at

Or if it is already formatted as a date- change the format setting to the date format you expect!

Format Cell-> Date-> pick format you need.

likehelpful

Date is stored as text then. You can use text to columns feature to get excel to read in the cells as dates

likehelpful

=RIGHT(LEFT(A1,5),2)+”/“+LEFT(A1,2)+”/“+RIGHT(A1,4)

helpfullikesmart

Up, up, down, down, left, right, left, right, B, A, Start.

likefunny

Another potentially easier way is to use the text formula
=Text([target cell", "MM/DD/YY")

This assumes the cell is actually stored as a date and will take care of all of the logic. It stores the result as text however instead of excels date code system

likesmarthelpful

YY/MM/DD/YY is the true preferred date convention

funnylike

👁👄👁❓

Example #72 of Posts you never see in the Advertising or Creative bowls.

likefunny

Oh okay 😊

=text(old date cell , "date format you want")

likehelpful

I’d just do two “text to columns” on the /, cut and insert column 2 in front of the first, and concatenate instead of complicated formulas.

smart

Ya and the complicated formula will take 5 times longer too (atleast, assuming you don’t typo). I can do the above in 10 seconds.

Thanks guys!!

You should have it as YYYY/MM/DD

Y’all use masks at indoor rallies?

Amazing how many bad answers there are in the responses for excel from a bunch of consultants

Really, bad answers?

Y’all need alteryx

Related Posts

Finally going to tell my bosses I am leaving to work with another office at our company! I’ve wanted out for so long! But now I don’t know what to say… I want to tell them off but probably shouldn’t. If you’re moving within the same company do you still give a 2 week notice? Do you just verbally tell them?

likefunny

How would one go about entering the FinTech realm?

like

Hey all - anyone currently utilizing an “adoption platform” for training end users while in a system implementation?

Success rates? Client satisfaction? End User adoption rates higher than traditional training?

Thanks for insights!

likehelpful

Can confirm guys
Source: r/iOSProgramming

Post Photo
likefunny

Hi, I have got an offer from HSBC at Analyst - GCB 6 for Business Analyst Role where the job title in the letter is given as Analyst.

I wanted to check if anyone who works in HSBC Global Transformation team can help me walkthrough the structure and the work culture in it.

like
like

Anyone have any insights into working at Amazon Music specifically? Looking for cultural insights on the marketing side of the house. Actively interviewing but these reports I’m seeing about Amazon’s work/life culture are slightly alarming….

like

About to start a new role as a technical program manager. I have more of an implementation/engineering experience so have always been on the technical side of things. How can I best prepare for this new role before I start?

like

Has anyone started a non profit before? What is the process to register or the best way to get it set up legally?

like

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

Hi fishes,
Could someone explain me what does this career level AM means in Consultant designation.
Thanks. Deloitte India

Post Photo
like

YYY, aren’t you on my level?

Post Photo
like

How can someone rejoin tcs

like

Hello! Recently laid off. Have 5 years of corporate and campus recruitment. I live in north New Jersey. Open to any hybrid roles in NJ or NYC. Open to any industry!

like

Anyone here on H1B? My partner is finishing up grad school and is looking for marketing opportunities that will sponsor. Any insight/tips on her job search would be really appreciated!

like

Looking out for Manual testing in SAP. Any lead will appreciated. YOE 8 Years

like

2 YOE in Healthcare Consulting. Have data skills in SQL, excel, PowerPoint, math BS

Looking for analyst, BI, or product manager role

Please dm!

like

Advice on Chief of Staff interviews?

like

Has anyone out there worked for a cruise line before? what was it like?

like

I had an agency reach out to me about a Sr. position but I turned it down. While I think my book stands up to Senior books, I’ve only been at mid-level for a year. What is a healthy time cont’d...

likehelpful

Additional Posts in The Work-Life Bowl

Anyone knows what happened to the flu?

funnylike

Between Austin TX and Charlotte NC, which is better to move to if we’re all going to be working remote for a while?

like

There should be a rule that when you say “happy weekend” on a Friday when you’re ending a meeting, you’re not supposed to be contacting that person anymore until the following Monday.

likesmart

Is it just me or is anyone else working from home with their tv turned on, or doing something else like watching youtube on their second monitors screens/devices?

like

If you schedule 12PM meetings for people who are in the same time zone and your thing isn’t urgent, you’re a MONSTER

likefunny

When was the last time you wore dress shoes?

likehelpful

My professional life at the moment is far from ideal. I’ve been on quarantine (long story, but a good one) for the last seven years. Royalties from my books don’t pay the bills. My entrepreneurial pursuits remain hampered. For the interim, I’ve been looking for a remote opportunity where I can leverage my skills in marketing, sales, social media, and elsewhere for a decent sum. I have a social media presence which, in recent years, reached millions. There has to be something exciting I can do.

like

My job just scheduled a large happy hour/meet and greet for June 2... are we really going to be able to gather like that so soon? Feel like that’s a bad idea.

like

I am so making this my new WFH set up!

Post Photo
likeupliftingsmartfunny

Have you ever worked in a toxic environment? What did that look like for you, and how long did you/ have you stayed?

like

How is mindtree for lateral entry with 9 years experience interms if work life balance and yearly hikes

like

Is there a videogames bowl?

like

Literally all I want to do is golf, but I’m not sure if I want to risk it out there

like

Anyone have success stories in dealing with an annoying neighbor? Guy next door has decided to blare loud music, have large fires, rev his motorcycle, etc. most days now that his wife and kids left him.

funnylike

How long was it till your puppy was fully potty trained? Have been on a good track but still accidents here and there

likehelpful

Those who live in studio apartments, how are you holding up?

like

The N.N.C. Federation has imposed new regulations. Please show your passport at Checkpoint. Prepare for thoroughly wash down with sanitizer mist.

Post Photo
likefunny

Pets! Time for an updated pet post! Show me your good boyz, fluffy gals and exotic pets!

I'll start: Gidget the labradoodle.

Post Photo
likeuplifting

Recommend Lupin on Netflix. French series cleverly done and sure to become a Netflix hit. Can’t wait for more episodes.

like

Any book recommendations? Mid 20s interested in health, neuropsychology, finance, leadership, and Christianity

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal