I have a daily report i disburse with a date at the top that is manually updated each day. I am trying to make it a formula so I can’t forget to update it before disbursing, I can do the =today()-1 to auto populate yesterdays date and when I try to set a custom format with ‘As of m/d/yyyy’ the s turns to a 0. Does anyone know why this happens or a work around ?

Anyone find a reasonable flight around Thanksgiving? I’m looking for somewhere to go over the holiday for 5 nights or so.

Was lowballed and don’t want to play catch up for the rest of my life. What is the best timing & ways to ask for a raise? Or should I exit to correct my mistake. Happy to dm with my specific info

Trying to leave agency life, but unsure of where to go next. Any successful transitions? Where did you go?

Figma: frames or groups?

Anybody hiring for sdets and or software devs got a few months of experience rn and would like to get some more $$ and hopefully fully remote

What carrer shifts could CSMs make?

I made the unusual transition from SDR To CSM. Considering switching roles or going to full on account management roles.

Thoughts?

How do one get a referral for a position in FAANG within data science? Sweden, Europe.

Wrapped up 3rd interview (including initial HR call) on earlier this week Director… when do you think I could get a offer?

Do folks here have life insurance policy in the US other than those offered by Employer ? Should we get one if on visa ?

How is the job security in Accenture?

On vacation and hallucinating the Slack ping sound anytime it gets quiet.

Thoughts on buying TWLO under 320 vs. SQ under 240 or neither?

What should be the ideal package for a SAP ABAP consultant experience of 5 years?

First time poster here!

After spending 4 years as a mid-level ops manager, I tried to break into HR through talent acquisition. Now after 6 years in TA, I've had a hard time getting out of it. My goal was always to get into a more broad HRBP position, but I've since worked for smaller orgs without a solid HR career path. When I ask about my career goals, they keep telling me, "Soon!" Or "Maybe in 6 months!"

I'm testing SPHR in June. Any advice for securing the type of role I'm aiming for?

Hi all,
I am working at PwC Kolkata for more than 2 years now,
I was promised that my salary will increase and as far as I know Partner has conveyed this request to the HR, but I still have not got any updates , so is it possible that , HR can deny the request, or they ar bound to do so ?. Who decides our CTC and increment ?

Thanks

What is job requisition number given by her of Capgemini

I work at a surety agency and we would like to branch out into P/C commercial lines. Anyone know anything for sale? Or where to look?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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)

Would anyone be willing to teach me vlookup?

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?

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?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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?

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.

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

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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?

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down