diceone

u/diceone


r/excel•

I am working on a solution to automate due dates for team tasks since they often put in weekend/holiday dates on accident.

For example: I have a task that needs to be completed in 21 calendar days and is starting October 22nd 2018, it would land on November 12th which is Veteran's Day here in the states. I'd want it to reflect that it needs to be completed on November 9th which is the last business day before the date due.

Another example would be 5 calendar days, say it was started Sept 5th 2018. 5 days (including the date started) would be Sept 9th, so I'd want the due date from the formula to be Sept 7th, 2018 (the last business day before that Sunday).

Is something like this even pos

22

r/leaf•

I have a couple of posts here, but essentially I purchased a Leaf in August 2017 from what I've come to realize was a shady dealer. The guys specialises in Leafs and I purchased a 2013 with 12 bars and 28k miles for $8500.

I test drove but it was not on a full charge, but I saw the 12 bars and had about 55 miles in range at 3/4 charge. All seemed good to me at the time. However, I got the car home and started using it to notice my fully charged range drop from 75 miles to being around 60 at 100%. Over the last 5 months the 12 health bars have dropped down to 9.

I purchased leafspy about 3 months ago and have been monitoring and see the following: AHr 42.14 and SOH 64%.

I contacted Nissan

311

r/Coyotes•

My wife surprised me with a weekend trip to DC to see the Yotes play the Caps for my 30th birthday. We're at Sky Harbor now - anyone else going to be there? Any suggestions on what to do while we're there?

I'm super excited!

86

r/Nissan•

Hey all, hoping I can get some suggestions here.

I'm a tinkerer at best with my car - I don't do much but try to DIY fixes here and there. A about 4 years ago my 2007 Sentra the LF window motor die on me so I was able to get the part from the dealer and replace it myself. It's been working fine for about 2-3 years, but as of this weekend the window stopped going down. I will press the down button, but nothing happens.

I can control all of the other windows from that switch panel, but it's just the driver side that's not doing anything. It doesn't even make a noise like it's trying like when the motor would "whirrr" before when it was dying. This same thing happened a few weeks ago, it sta

31

r/fixit•

To give some context, we bought our house back in 2013 and it was a flip. It was our first house and honestly we didn't know certain things to look for and over time we've realized that the flipper didn't know what the hell he was doing. The first day we were in the house after all was said and done I decided to clean up after a long day of moving in and discovered that the idiot had installed the shower shell incorrectly and it has a low spot on both sides of the drain so it does not drain.

Over the past few years we've been using a squeegee to get most of the water to the drain, but as you can see from the pictures it's starting to stain and it's really just a pain in the ass to do every

31


r/GCXRep•
  • Redditor since 11/9/2010
  • If you have been linked to this page, please make sure that you're on the real r/GCXRep, and the user who linked you was indeed me, and not someone with a similar username trying to impersonate me. Note that just because you're reading this doesn't mean a scammer didn't include this note in their fake profile to trick you into a false sense of security. Double check, and don't get tricked or scammed!
10


You've reached the end of this feed.