Does anyone know how to reformat a date from yyyy-mm-day to month-day—yyyy?

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

Select the range -> Ctrl +1 -> custom -> type "mmm-d-yyy"

like

Ex.: consider 4/21/1985 (month/day/year).
The current format is "m-d-yyy"
"mm" will add a 0 in the month - 04
"mmm" will make it Apr (from april)
"d" will display the day as 21, same as "dd"
"ddd" will display Sun as this was a sunday
"dddd" will display the full name (sunday)
"y" or "yy" will display the last 2 digits
"yyy" will display full 4 digits for the year

It's possible to display B.C and A.C but I don't think you will actually need it

like

Alt, H, N, “Short Date”

like

Yes, text(MMM-dd-yyyy)

Right click > format cells

Right click>formal cells>custom category>in the box just below "Type:" type mmmm-dd-yyyy

Thank you all.

Related Posts

Hi beautiful people! So I’m actually really nervous and crying while I type this but I joined this bowl because I think I’m bisexual. Struggling with how to come out though

likeupliftinghelpful

Can’t sleep. Any ladies want to chat? 👩🏽

like

I feel like I wouldn't get many tips as a server because I'm a guy, is this really true or am I just making it up?

like

Is online dating the way to go during this time of social distancing?

like

How do you know if he or she is into you? 😃

like

I (28F) went on a date and everything was going great until the guy (33M) revealed he was currently carrying an active handgun on his belt for protection. I talked to some friends and family about this and they don't think it's a big deal. The date was otherwise really great. I just can't seem to get over this piece.

Has anyone ever been in a relationship where you had differing opinions on the gun control debate?

funnylike

Noticed that some women here are way too comfortable touching people they don’t know on the street. Just because I’m a man does not mean you can put your hands on me or do things that would get you punched in the face if you weren’t a woman.

like

I‘m 30 and kinda enjoy being single. Wondering how life is as a single when I‘m 40,50,60,... Can anyone share their experience?

like

How do u convince wife for sex ?

like

I miss the times (circa 2006 - 2010)where it was quite normal to go out and meet girls and have them take you back home for the night. Such a great time to be alive. Now, everyone is so caught up with that digital app dating life and no one goes out anymore to meet people. So sad.

like

I’m testing out my new “Pro” status in the real world.

I went to a coffee shop today, ended up chatting with an attractive, interesting, and kind woman who also happened to be single. I asked to exchange numbers but she said she’d just take mine. Stay tuned to see if she texts or if I get ignored!

like

Haha this is going to sound pretty shallow, but are there any young guys that are on good looking/masculine/dl-ish side looking to chat/snap? 22M here

like

Anybody meet up strictly for hookups? I wouldn’t mind if anybody would fly me out. 👩‍🦰

funnylikeuplifting

Looking for a sugar mama👀

like

Riyadh fish, what are some good compounds/complexs that you would recommend for solo male? Preferably not too far from centre & with a decent international crowd.

Cheers

like

Hwllllooooo
Female mid 20s

Thoughts on convincing gf to stay? 27M dating 28F for ~1.5 years. We knew each other in HS and reconnected during the pandemic. Everything was so connected, compatible and hot, and we planned a life together. We thought we met the loves of our lives. We moved to NYC in January. Lost intimacy and connection. She’s unwilling to work on things. Such a genuinely talented and beautiful woman, but has trust issues and depression from being overworked. Thoughts on convincing vs surrendering / leaving?

Sigh. Do 5 things right and get stuffed by the partner on the 1 thing. Feeling like crap, despondent because this guy clearly hates me now and I was trying to prove myself on this matter. Down the toilet and into the shitter here we go

like

What exactly counts as ghosting . ?
You go on a date spend quality time , you have some intimate moments and the next thing the guy does is unmatch you on the app without sending a text.
Does this count as ghosting ?
Is expecting a text from other person saying " this is not what he is looking for " is too much to ask ?
This kind of behaviour puts other person on the self doubt mode.

like

What are your biggest regrets in dating? Anyone regretted staying with someone for too long?

like

More Posts

Hello Bosch Fishes,
What is the current company wide work policy ? Is there is a strict return to office mandate like tcs ?

like

Hi,

Since there aren't enough characters to type in my request, I have added a snap of it. Thank you for your time!

Post Photo
like

First year Paralegal here - graduated from a small liberal arts school and have been working in the corporate practice at a well ranked firm. The majority of my experience has been working in private funds, financings, some M&A, and limited Real Estate work.

I think I enjoy the idea of a few years in big law after law school to pay off loans (undergrad+law school), but am not sold b/c I have been remote since I started in January and rarely get to interact live with deal teams. How can I tell?

like

I have been working with @Apisero from last 2 years. My current CTC is 8 LPA. How much increment should I expect/demand in this Hike Cycle?

Those who joined @Apisero recently with similar YOE. How much CTC was offered to you for Senior Software Engineer position.

Thank you!

like

Has anyone done earthquake retrofitting for a house NEWER than 1980? I know it’s a must-do for houses OLDER than 1980. But my house was built in 1988, so it’s not required.

Several contractors provided estimates, in the $40k-$50k range, which seems like a lot of $$$.

Apparently our house has bolts but not enough and not the right kind, plus it needs joist blocking and shear paneling. All to meet codes put in place after our house was built.

Just curious if others have done this.

like

Hi,
Could anyone please refer in Wipro as there is a relevant opportunity
Thanks in advance 😊

like

Will we be able to see what rating we have got in the appraisal as in TP, DA?

like

Can some please refer me for angular position in L&T

like

Looking for some fun manifesto spots for inspiration. Any suggestions welcome!

like

Does A&M hire people in cities without a FDD practice now things are remote? Or would you be required to move?

like

Does anyone have tips for negotiating salary or other perks specifically at a nonprofit?
SDZWA has a large research side that many don’t know about but the pay is rubbish compared to other research organizations.

Hi everyone, I have 3.5 yoe serving notice period which is still 25 days remaining, I have 3 offers 9lpa with accenture, 10lpa with cts and 13lpa from a startup. Can I negotiate with CTS or Accenture? How much I can expect as a counter offer?

Anyone have success using social media to elevate/create their personal brand and willing to let me quote you for a project? I want to know what channels and tactics you used specifically and what success you found. Did you find clients, jobs, other opportunities, were you able to help someone else?

Thanks!

like

Looking for performance/show recommendations. Have you seen anything interesting lately?

like

Hi, I'll be joining Wipro 28th September. Any idea when I'll get hike? 2023 or 2024?

like

Anyone hiring for remote senior accountant roles? I have three years of public accounting experience and a CPA.

like
like

Just got out of a meeting with a client. Talk about uncomfortable- they'd fired their director that morning and he ran in screaming at the team. They ended up calling security to kick him out!

Moving to Austin soon! Where’s a good place to rent a 3 bedroom unit?

like

Additional Posts in Excel Genius

Any one good with Tableau I have a question

like

I'd like to know if anyone has ever pressed the excel help key (f1) on purpose. It is literally the most useless and obnoxious shortcut for excel. I accidentally press it 5 times a day at least.

likefunny

I’m using a pivot table to show how different initiatives fall under broader themes. If I’m screen sharing the pivot table w my audience and we make a live edit to one of the initiatives on the table itself, is there a way this can also change the initiative in the source data?

like

does anyone know what CVS medical excel assessment for finance analyst consist of? I have an interview in a few hours

like

Is there an enhanced "sumifs" that will sum rows and columns based on two different criteria?

like

Can anybody tell me how one can open a list off all tabs to navigate in a workbook with many tabs?

like

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

What are your favorite excel macros to make you more efficient at work?

like

Hi all!
I have a file that is full of hyperlinks to different files in another folder.
I moved the location of tbe original fil and hyperlinks stopped working.
Now I also want to move the location of the hyperlinks folder.
Is there a way of fixing the links? (File names are still the same)

like

Is there any way to compare multiple index match formulas. Looking to find a match across three different tables on three different tabs. Most I’ve seen is using if error to compare 2.

like

Thoughts on creating a dynamic remove duplicates model, where someone can place raw data in one tab without having to manipulate? I've used if(index=min) which works but anyone have a better way..

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like