Alright formula pros, I need excel to filter if a date is farther than six months in the future. I'm thinking I need a column to mark these rows. What formula do I need? Looking for the most efficient solution!

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

ChatGPT can tell you formulas too by the way, I use this at work all the time

like

Can use copilot for this too.

like

Depends on your definition of 6 months, if it's by calendar date and/or by the month start or end. And if you are using today as a reference.

This should be what you're looking for if you're just going by exactly 6 months from today and if you're not including exactly 6 months from today within those 6 months.

=IFS(
Cell <=EDATE(Today() , 6), "No",
Cell >EDATE(Today(), 6), "Yes")

helpful

Just use the =filter() formula boss

Related Posts

Why don't we choose a time date and place

Anyone know a place to safely meet other kinksters?

likefunny

Most cringeworthy pickup lines you’ve seen on dating apps?
I’ll start: “Are you my appendix cuz I want to take you out”

likefunny

Need to kind of just runaway somewhere for the summer for mental health reasons…any recommendations on a place where it’s easy to meet people?

like

Need advice. Very Shy guy and girl, met a while back for a side hustle both like each other a LOT, relationship has progressed in other areas but not in the physical realm, primarily because neither officially asked the other out. Guy is a very rough around edges, asked for a date by saying ‘anytime you need breakfast or lunch, let me know’. I am an independent gal and didn’t like the way it came across. I really want to take this forward but am out of ideas on how to make a date happen.

like

Any female fish want to grab a drink this weekend?

like

Gonna be in Denver for a couple of days in mid-July, anyone down to play tour guide? Can promise flirty conversation + cocktails at the very least…perhaps more if the vibe feel right. 30 M, tall and, dare I say, handsome…in case that matters 😊

funnylike

Pune office lo evaraina flatmate kosam chustunnara ?
M here , dm me if we can take together, i am searching this weeken

like

30M based in nyc. Any F ready for casual dating? Happy to DM if interested.

like

Any F in nyc wanna hang out this weekend? 30 M here.

likefunny

Saw a post in the confession bowl so I wanted to check this bowl out. Any hot, smart, rich and single guys in this bowl?😁

funny

Which city would you recommend for single men in late 20s trying to find good opportunities in career & dating? Leaning more towards to NYC but not planning to live in Manhattan due to the high rent so I am not sure that would be okay. Also don't want to drive that much.

like

So I just recently got into dating after a break up 3 months ago. I joined some dating apps and have been getting quite a few matches. I’ve never dated anyone like to a point of going on traditional dates. Basically, I have no clue what to do on a date once i have one planned. Like I’ve been on a few and it’s been just talking but I guess I have no clue what to do after. I’m probably just rambling at this point but basically I need advice on actual dates and how to feel it out and what to do. Ty

likehelpful

I’m 30. My friends’ weddings are piling up and I’m just... still very much single. Feel like it’s acceptable in NYC but also sorta depressing. Dating is hard.

like

I saw my friends text messages (iPhone) and saw that she was texting a guy she shouldn’t be texting. She told me that the “Maybe” function on her iphone is glitching & the wrong name shows up. Cont.

I’m really struggling with figuring out my sexuality and dating as I enter the next phase of my life (into my first job). Not out Bisexual male - uncertain about dating. I want to try going out with girls but scared that they would think about my sexual history(got with guys and girls before). Anyone in a similar boat?

likefunny

NYC 🐠 Anyone try the dating app MOTTO? Any good?

like

I love when randomly talking to a straight man and they out of nowhere say “I have a girlfriend” all shaky and nervous. It gives DL guys in sweatpants tease and that I’m doing something right 😂

like

Ideas for a night in alone? Feeling Chinese take out to start it right

like

Can’t tell if I’m developing crushes on my coworkers only because they’re the only people I interact with (on zoom) in quarantine 😬

More Posts

Hi Fishes & Sharks,

What will be the in-hand salary? Please guide.

Post Photo
like

Any idea how long FIS global Pune is allowing WFH?

Hi, I got an offer, could anyone please tell what can be the In hand salary. What is Lead Engineer role??

Post Photo
like

Real Estate Rookie podcast thirsty for subs

Post Photo
likefunny

I took consumer behavior classes in school and I’ve seen bits and pieces of it in my job as a media planner, but I want to do it full time. What career opportunities exist for consumer behavior?

What will be inhand salary?

Post Photo
like

Can anyone tell what would CTC TCS offers for a 15.5 Exp resource. What would be the best designation one could expect to be offered with 15.5 years of exp.

like

Hi fishes may you please confirm the below:

In the offer letter the "Provident Fund" And "gratuity" Is mentioned. In the salary calculation in hand, we will not consider these amounts right? As these components are received when someone retires..right? .. Please confirm.

Thanks in advance

like

Hey everyone! I’m a couple months in of trying to find a SDR role. Does anyone have any advice for interviews or just to stand out from the crowd? Any advice would be much appreciated!

like

Deloitte Cyber, how long did it take you to receive an offer after final interview?

like

What’s the expected salary with a bank for a Product manager role in NYC?

Any range?

Do banks offer stock options? ( Ex: BofA, JP )

like

Openings at Commonwealth Bank India

Having experience in Data Analytics 0-3 years.


✉️Send your CV -
niket.kedia@cba.com.au

➡️Subject - Analytics at Commonwealth Bank

👨‍🎓👩‍🎓🧑‍🎓 Freshers are welcome to send CVs.

like
like

How soon did you know the practice of law was not for you, and when did you start acting on it? Approaching my second year and have felt this in some form since my six month mark.

like

I’m struggling. I left an agency I liked last year due to growth limitations and since then I’ve worked at 2 different agencies and can’t seem to find my footing. The first one seemed like a good fit at first but then it turned out to not be the best place for me so I left. At my current agency I feel super undervalued. I’m always raising my hand and offering to help where I can and no matter what I do, I don’t feel utilized or valued or part of the team.It’s really taken a toll on my confidence

like
like

What’s the biggest point of pain for you Indy’s, that tech or other services hasn’t fixed yet?

like

Currently have CSR and thinking about downgrading to one of the Freedom cards. I currently have 150k in points. How would that effect it if I were to downgrade to a Freedom card?

like

Traveling to DC for 4 days. Looking for Marriott with parking and maybe concierge lounge functioning. Anyone use a Marriott recently they can recommend?
Open to other suggestions too. Thanks

like

I need you help to work in you country i want know you country and your culture

like

Additional Posts in Excel Genius

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Still don't have xlookup. #fomo

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Anyone know what these badges are?

Post Photo
likefunny

How do I compare two sheets to make sure they are identical?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Would anyone be willing to teach me vlookup?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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

Scan your QR code to download
Fishbowl app on your mobile

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