Trying to use excel to double check future dates for scheduling orders and looking for input on best formula to use. I want to make sure that if the future date falls on a weekend, the return date is the preceding Friday/workday. Eg., start date in A1 and want my return date 180 days in the future, but if future date is a weekend, I want the return date to be the preceding Friday/workday. I thought I had it with WORKDAY, but one of my inputs must be wrong because it’s only working for some.

Just found this bowl! Just getting into cycling .. what would you saw are a few essential items to start with outside of helmet , spare tube, jersey/shorts etc. I was thinking a garmin, or nice lights

One of my frustrations with myself (writing it out here so I can work on it) is that I will print out something that I need, such as a traffic collision report. I will read it without actually reading it. This results in spending time without actually retaining info. Does this happen to anyone else? I’ve found that I can actually focus when I truly force myself, but often this happens after I’ve discovered an error or an important piece of information that I should have noticed earlier.

Any advice for a young engineer trying to land their very first job out of college?

Anyone hiring for Workday HCM AMS ?

How much should I ask for for an Art Sup role?

Hi 🐠, connecting documents for I-485 filling. Any insight on the medical check? I don't have vaccination records. Is this required?

I have 7 YOE and applied for a position that is L4. I feel as if I’m overqualified for the position, but the Recruiter told me that when they say L4, they are actually looking for someone with 6+ years of experience. Is this true? I feel like I should be looking at L5 with my experience

Two years out of undergrad and already considered a "strong senior" (A2 ->S1 this year) This can't be sustainable for a firm. Where can I go that will actually put me in my place and teach me a lot??

Looking for some material for a crash course in IT strategy consulting - books article etc. any recommendations would be appreciated

Anyone joining Citi on 5th dec at Pune location?

What is your hours worked to hours billed ratio?

Hows wlb and projects of HCL Singapore?

In how many days, BDO rise give reply to your interview 2nd round? Anyone here from BDO rise here?

Friday is here 🤩

Hi all,

Can anyone tell me the joining bonus clause in tiger analytics?

Any one understood what Steve said about compensation and bonus revision yesterday ?

Looking for job opportunity in Poltury or Aquaculture for kolkata West Bengal

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Would anyone be willing to teach me vlookup?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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.

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

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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.

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.

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.

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.

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.