Calendar question re excel:

Does anyone know if there's a way to exclude holidays when calculating a date in excel? Or to exclude a range of dates where I could insert a chart for holidays to exclude? I tried the WORKDAYS function, which works great, except it excludes werkends and holidays. I'm looking for a way to exclude holidays only.

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

Related Posts

Anyone do a duvine bike tour?

like

Hi fishes,

Can anyone tell me if infosys promotion is happening as part if retention? Mostly from jl5 to jl6? Did anyone get promotion as part of retention? in infosys?

like

I got an offer from UST Global and its WFO. Just wanted to know whether everyone else ,who joined recently, is also getting WFO only ? What about other employees- is it wfo for all now ? My DC is in Trivandrum.

like

I was fired after I reported a partner for a serious (criminal) ethics violation. The firm covered it up. Are all companies like this in the end? I’ve lost my trust and don’t know how to start over.

like

Other than Medtronic, which med device companies would you consider the cream of the crop?

like

What do you all think of bioinformatics as a field? Thinking of doing a masters to specialize in it. Have 4YOE at a T2. Do you think its worth it?

like
like

Coforge Referrals

Job Location – Pune, Hyderaba

Role- Java Fullstack – Analyst
Skill –Java 8, Springboot, Microservices, Angular, React JS/Redux
Experience – 4 Years to 11 Years

Role- Java Microservices- Analyst
Skill –Java 8, Microservices, Spring, Springboot, REST API, MVC
Experience – 4 Years to 11 Years

Role- Data Analytics – Analyst
Skill – Data Modeller , Data Mining , Data Modelling, Data Analytics - Any tool / BI Tool Like Tableau / Qlicksence
Experience – 5 Years to 10 Years

like

Hi , wanted to get some feedback on following position offer in New Jersey area
Senior Manager for pricing startegy
I have 4 and half years of related experience,Masters degree
Base salary offer at 150k, 21% SPI and 10% LTI
How much room I have for negotiation, whats the fair market rate for this level?

like

Can a company from US hire a dev from India directly? On usa payroll?
Or would there be legal issues in doing so.

like

I’m a 9th year in a mostly litigation-based practice group at a one-tier partnership firm. My group’s billable hours have been low the last few years, so making partner will be nearly impossible, and a counsel position is not viable long-term in my group. What’s the best option here if partnership is the ultimate goal? Try to get a NEP/counsel position at another firm, which is likely difficult in my market, or offer to take a class cut by a few years?

likehelpful

Walmart hr collected all the documents from me but she hasn't come up with an offer from the last one month...., Will Walmart give me an offer or not??
@walmart

like

How good is to join @coforge as senior developer

like

Hi Fishies,

Please give some advice/input , Need to know the names of good Product/Service based organizations which have good WORK LIFE BALANCE, Good Environment to work.

Skills : C# .Net Developer, WPF/WCF.

like

Whats the salary of Ops Manager in Pune with 15 yrs. of Experience.

like

Hi Amazonians, What if I do not submit any idea from last 6 months in RBS. Would they put my name in PIP ?Amazon

Urgent
Hello guys, Tomorrow is DOJ in INFOSYS and I have asked 1 week back for CTC revision by showing CGI OL and my HR told me that I got all approvals and will send my revised OL. Till now I didn't get. Yesterday HR told I will get it today. My DOJ is tomorrow. I am tensed. I have asked the CGI to offer to revise my date to dec 10th. Will infosys give it today or they are double crossing me?

like

What is the average annual hike in PwC advisory business like for ex let's say ops consulting.

And how much is the travel like in a month? How comfortable are the stays etc.

I recently received an offer for senior associate position, hence the ask. Thanks in advance.

Was the advertising industry always such a sweatshoppy, bad WLB industry? Or is the more of a modern thing?

like

Additional Posts in Law

How long does a Defendant have to oppose a motion for leave to amend a Complaint in Florida for a matter pending in the Eleventh Judicial Circuit, Miami-Dade County?

likehelpful

Why are read only documents called “riders?”

like

Anyone want to give me retroactive FOMO by sharing stories from their summer associate programs? Mine is entirely virtual, and needless to say we are less than enthused by what we’re missing out on

like

I have a lot of mindless closing binder assembly today so I’ve been watching Restrepo and Korengal in the background. It.... really puts things in perspective. I feel like such a baby for complaining about long hours or stressing over emails.

like

Can I waive into other UBE jurisdictions using my NY UBE license at any time? Or is there an expiration date for my bar exam score, after which point I won't be able to waive in?

like

Why do partners tell associates to be cost-conscious when billing for certain clients when they can just cut your hours on the back end?

like

Anybody know the starting salary for a second year associate at Gray Robinson in Florida (not Miami if that makes a difference)? Thinking of a lateral in and want to know what I’d be working with. Bonus structure? Minimum billable req.? Bueller?

like

Does anyone know the typical salary for a 1st-2nd year associate at Lewis Brisbois in Los Angeles? L&E

Any thoughts on Latham’s IP Litigation practice in the Bay Area?

like

Is it wise to go in house to a product and privacy group after 2 years in commercial litigation?

like

I’m a second year BigLaw associate that pays market. I was offered the position at a modified salary and hourly expectation due to their expected work flow needs. I’m wondering what is the best way to approach the topic of getting on the full salary/hours. Do I wait until the bonuses are given at the end of my first year? Or bring it up at mid-year review? I won’t have any problem meeting my hourly so I’m starting to think I’m being underpaid. I’ve been reading on here that not meeting

like

I recently floundered professionally and realized that the reason was I expected my relationship with my job to fulfill all my human needs and when it didn't I had no idea what to do. So just a reminder to prioritize the relationships in your life that give you meaning, your job is one of them but it's a poor life if that's the only one. Have great relationships with your friends your family and yourself

likesmarthelpful

Anyone here wash out of biglaw before making it a full year? How’d it work out/where’d you end up? I’m almost six months in and I’m starting to think I’m just not built for this.

like

Not law quite law related but I could use some input: anyone have any luck negotiating lease pricing with a corporate landlord? I originally signed and got covid pricing and now they want to hit me with a 17% increase bc of inflation 🙃

like

How to follow up without sounding desperate? I already let them know I have competing offer expiring. They promised to get back to me multiple times but still don’t have final decision from them despite positive feedback.

likehelpful

Pro tip I wish I received: when lateraling back up your phone before leaving so you don’t lose it’s contents when your previous firm remote-factory resets the device.

likehelpfulfunny

Rising 2L here…Just found out yesterday that one of my top target law firms is not participating in OCIs (they don’t have offices in my state). Any advice on the best way to move forward with them? Still planning to apply, just want to know what I should be doing. Thanks!

like

Does anyone know the starting salary for Jackson Lewis in the firm's Connecticut office, as well as the billable hours requirement?

like

Is anyone aware of a tax software (e.g., TurboTax) for preparing a form 706? For personal use, so cannot be a commercial license only product.

like

How does one transition from litigation to transactional? Am in labor and employment lot. 4th year.

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