SpreadEveryone: The Fetchland Excel wire

97 watchers
Jun 2021
4:39pm, 21 Jun 2021
15,048 posts
  •  
  • 0
NDWDave
Clean up in Column M!
Aug 2021
7:12am, 19 Aug 2021
128,753 posts
  •  
  • 0
GregP
It may amuse regulars to learn that I was stuck just now building a thing to prioritise growth bids and resorted to nicking a bunch of formulas and stuff I developed years ago for the Fetchland Deathmatch Engine. :)
Aug 2021
10:15am, 19 Aug 2021
15,195 posts
  •  
  • 0
rf_fozzy
Deathmatches are not there for amusement.
Aug 2021
10:21am, 19 Aug 2021
128,767 posts
  •  
  • 0
GregP
Indeedles :)
Aug 2021
12:11pm, 27 Aug 2021
128,993 posts
  •  
  • 0
GregP
Anyon else think =NETWORKDAYS() shouldn’t by default need you to always subtract one from the outcome?
Aug 2021
12:18pm, 27 Aug 2021
62,402 posts
  •  
  • 0
Diogenes
I don't know, but I will always think of them as a great opportunity to connect with people.
Aug 2021
1:13pm, 27 Aug 2021
7,248 posts
  •  
  • 0
paul the builder
I can never remember whether I have a strong opinion about if functions like that should definitely be *inclusive*, *exclusive*, or counting-one-but-not-the-other.

So I always check before using.
Aug 2021
1:19pm, 27 Aug 2021
128,995 posts
  •  
  • 0
GregP
Hm. I think the number of days between next Tuesday and next Wednesday is probably one.

Or none.

=NETWORKDAYS() returns 2
SPR
Aug 2021
1:21pm, 27 Aug 2021
35,176 posts
  •  
  • 0
SPR
Don't you end up adding 1? If I do NETWORKDAYS between 23/08/2021 and 27/08/2021 what's the answer? I'd want 5 but expect 4?
um
Aug 2021
1:22pm, 27 Aug 2021
5,076 posts
  •  
  • 0
um
As per web 'explanation' ... if you start work on Monday and finish on Friday, how many days do you want to be paid for?
Would you settle for 4?

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work









Back To Top
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 112,110 Fetchies!
Already a Fetchie? Sign in here