Trying to return a future weekday (Wednesday) in 2 weeks when A1 = reference date. I used =A1+14-WEEKDAY(A1+14-4). It works in all cases EXCEPT when the reference date in A1 is also a Wednesday. If the date in A1 is a Wednesday, the return date ends up being only 1 week in the future instead of 2. Any ideas how to correct without having to change the formula for just the days with a reference date falling on a Wednesday?

I stopped contributing to my 401K for the last three months in order to pay off credit card debt. I am 28 and have about 68K in my 401K. Was this a smart decision? I want to get out of debt as quickly as possible and I have no student loans or car debt.

My company covers in depth results each week, including meetings set/attended, wins, revenue, retention etc. I feel as if evaluating in such depth is detrimental to the psyche, as you never get to “ride the high.” In addition, some weeks are simply slower than others, and it’s not always representative of what the results at the end of the period or quarter will be. Is this not a big deal, and I’m I placing too much importance on it? Or is it beneficial to review results less frequently?

Anyone heard anything about Dept Agency on Causeway? Specifically what it’s like for agencies that have been acquired by / roll up to them

I’m looking to hire a social/community person ASAP. Building a team for F500 co. Know anyone?

Is Al’s Subs better than Casa Razdora? Why or why not?

Looking for an art partner to come in at the ACD or what my agency calls “group art supervisor” level. Fair warning: it’s pharma, but business is really healthy and leadership usually fights really hard for creative that doesn’t involve couples strolling down the shoreline hand-in-hand :) Hit me with your book if interested

Hello Boston folks...any insight on recruiters in Boston/New England area? Reached out to several but looking expand my coverage and possible opportunities both client and agency side. Any names & numbers would be most appreciated!

Hi Fishes,

I have 7+ YOE as a SAP Functional consultant. I am trying to learn and switch in SAP BTP.

Can someone advise roadmap to transit to BTP? Also how much coding involved in BTP?

Recommendations for a weekend in SF?

Is this a good weekend to visit dyker heights? Or is it worth waiting?

Please DM for referrals in Oracle
Vacancies for
Java/JavaScript front end developers
Software developer
Tableau developer
Core Java
Senior Test Engineer
Cloud Infrastructure

Locations- Bangalore, Hyderabad, Pune, Trivandrum

Hello everybody,

Could you please recommend companies with Internships in Front or Back End Development?

Does anyone here work for an RIA? If so, what’s your experience like?

New to Chicago - how do I find new friends here?

Looking to take my team out for drinks and dinner somewhere in downtown/river north. Any recommendations?

You can use this bowl to chat with other team members

28 / F / LA / 73k / Im underpaid, huh

Which sports team do you think has the best, freshest, and most engaging advertising/marketing and social channels?

Time sensitive question, have two offers. One is GIR in SLC with GS. Other is Generalist Consultant at McKinsey. Which would you recommend (McKinseys offer is slightly higher but assuming due to location). Thank you greatly for any insight! Hoping to get into private equity in the distant future

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

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?

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.

Still don't have xlookup. #fomo

Would anyone be willing to teach me vlookup?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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?

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.

How do you fix microsoft excel cannot paste data error?

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.