How can I make these dates sortable with a filter?

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

Highlight the column and convert to Date

like

Text to columns to separate the date by year month day , or use yyyy/mm/dd format

like

Try text to columns. I’ve found as a last-ditch effort to correct corrupted cell formatting it’s incredibly effective

like

Select the column & covert all the dates to the same format like mm/dd/yy etc
Use field format as date and not number/text
Then you should be able to sort

like

Text to columns, fixed width. Import the first selection as a date m/dd/yyyy. Skip import on the second.

Could also try =trim, hardcode , and then change to a date.

like

You can also use the TEXT function to return the portion of the date and concatenate it, for example:

=TEXT(B2,"Mmm")&" - "&TEXT(B2,"dd")

Would return Jan-04 from the value 04/01/2020

And that would then let you filter/sort by month and day.

IFERROR(DATEVALUE(B2),B2)

Hmm for whatever reason when I try to convert to YYYY/MM/DD it doesn’t work

yes, as A1 mentioned, as a last effort text to column then concatenate then format the cells as date. annoying but effective

Trim() and trying to math, like +0, usually works for me if you dont want the text to columns solution

Multiply by 1. Input 1 somewhere outside the data, copy it, highlight the dates, alt + e + s + m (multiply by 1)

Related Posts

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

so any girl bored af just tryna chat?

like

I may be separating from my partner after catching him sexting randos for the 5th time. Hundreds of dollars in therapy later, I have hit my limit. Anyone have advice on single parenting a toddler?

like

Looking to meet a F as well. 31M. NY/NJ/CT area. Short, stodgy and balding (imagine a brown George Costanza). Actually, no glasses - I had vision correction surgery. Any takers?

like

Do people coordinate play dates with colleagues that have kids around the same age? Trying to find alternatives to happy hour...

Any 40F interested in connecting?

like

Why is this bowl not called “singles..” or “dating...” smth? I literally didn’t know this bowl existed until someone just pointed it out to me🤔

like

Did anyone have a relationship with a non desi? Do you see any difference between dating a desi and non desi?

like

Anyone know what's the dating scene is like in RVA?

like

Would you consider having dinner w/ a coworker of the opposite sex on a Friday night a date? Not sure if I’m misinterpreting the situation

likefunny

Who wants to link up this weekend, drinks on me. I’m M 🐠 btw

likehelpful

Is there such a thing as over texting the person you like?

like

30 M. Indian. Born in India but moved to US when I was less than a year old. Looking to meet someone, iA.

Name the reaction you get when you tell dates you’re a lawyer:

like

Week 1 Dilemma: Damien Harris v Amon St Brown v Jacobi Meyers v Rashaad penny. Please help pick 3 from this group for flex. Full PPR league.

like

Moving to Austin . 30 M any F around to catch up dinner lunch and city trip

likehelpful

For those of you in your mid-20’s, how often do you go on dates with your significant other? In a serious relationship for the first time since college and trying to gauge what folks consider normal for dating frequency (excluding nights in). Context - we’re 25, dating for 3 months, live 5 mins away from each other, decent WLB

like

My wife once said having sex with me was a chore because of my libido. I told her to have sex with when she wants not when she feels obligated too. Now we have sex once a month. I feel awful because I started paying other people just to touch me.

like

What’s the right age difference? My friends set me up on a date with a girl who is 12 years younger to me. I was feeling so uncomfortable all through my dinner with her.

Anyone around Chicago and suburbs for general merriment and dating. 32 M, tall and a fit built

More Posts

Jr AD presenting his idea in a meeting with clients

Post Photo
likefunny

I’m interested in reaching for a position as manager for a local retailer, but I hate having to play the bad guy. How can I become more comfortable with fulfilling that role?

like

Any PowerBI consultants out there? Curious if the need for this is really out there, how lucrative it is, and what other skills help in your process (sql, python, etc)

Tks!

likefunny

Are you buying ETFs or are you putting your money in a HYSA?

like

Any logo designers here? I’m building a website for a friends music group (classical, pop, jazz genres) and they’re in search of a designer to create their logo (they’d pay up to $900).

Anyone interested?

like

VAR and these handball rules are an utter joke.

like

How to win awards? 😢

likefunny

Question for senior bankers - how far along in your career did you feel like you got your life back?

like

How do you find a work place mentor?

like

Need help for house hunting folks.
My office is in Brigade Metropolis and my husband's in Prestige tech park, near Goldman Sachs' office.
We are looking for a house that would be convenient for both of us to travel to and fro.
Can someone please suggest some good localities or housing societies which would be affordable?
Any other resources would also be appreciated as we are new to the city

like

New to mountain view and trying to join a recreational league to meet people. I have no experience in team sports but anyone have space in their league team that I can join (soccer, softball, basketball, etc)? Late 20s F, so would want a coed team.

like

CAIA or CMT?

I do institutional sales for an asset manager. Am graduating in the fall with an MBA from a top 40 school. Would like a designation but dont want to do the CFA.  Between the CAIA and CMT: which one is more applicable to asset management, and better status/recognition? appreciate any insight

like

Nyc couple with $0.5m in income who feels average

Post Photo
funnylike

Anyone done lofoten islands or the kungsleden trail? Would love some more info. Thinking of sept date to avoid crowds.

What is everyone's favorite worldtimer?

Reasonably priced I think I'll give a nod to the Chopard L.U.C. Time Traveler One.

Post Photo
like

Hello Fishes, Need Software Engineers with strong Java experience. Minimum experience needed is 2. This is for Nokia. Work Location can be Chennai or Bangalore based on your choice. Interested folks please DM me your resume. Along with your YOE, CCTC, ECTC and Current Work Location & Preferred WL.

Post Photo

What is the infosys bangalore location?

like

Hi Fishes
I am a passout of IIIT Sonepat.
Lookin for Java developer profile as a fresher in Banglore.
Can anyone refer me?

like

Can you book business or first class if the flight is 5 hours?

likesmart

Anyone free to practice tomorrow/Monday?

like

Additional Posts in Excel Genius

Is there a good tutorial out there to automate creating pivot tables and then creating a PowerPoint pres with those pivots? Trying to do with with macros and the syntax is really giving me a hard time.

likehelpful

While I was helping an intern with an excel formula I told them to lock the references using F4. Since they were working on a laptop that has special function keys I mentioned to her that they would have to press the fn key and the f4 key at the same time.

Well they pressed alt+f4 instead of fn+f4 and proceeded to lose their work:) fun days

likefunny

What are the most important Excel skills to have to grow in the Consulting industry?

like

I am trying to do a sumif formula for values that fall with specific dates. It worked for all but one of my cases. Not sure what I am doing wrong. Every other case worked. For some reason it’s adding more than it should. When I move the sum range up one it resolves the issue but that throws everything else off. Any help would be appreciated

like

What are the most important excel skills and formulas an Assisant Buyer should know?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

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

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

I’m struggling with some pivot charts that are connected to an update button. When I update the excel sheet, the formatting for the secondary axis is removed. Any solutions?

like

Any one good with Tableau I have a question

like

Hi Gang, I have voluminous pdf bank statements that I want to convert to excel with the formatting. What’s the easiest way out?

like

Suppose I have a table where column Aksts groups and column B lists subgroups (so there are multiple unique values in B for each unique value in A). With pivot tables or anything else, is there a quick way to just get the taxonomy for A and B? Basically the output would be a table that shows Group 1 in A with all of it's subgroups, followed by Group 2 and it's subgroups, etc.

like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Anyone know a good way for converting MS project to a nice formatted version in PowerPoint (without buying additional add ons or converters)?

like