SpreadEveryone: The Fetchland Excel wire
97 watchers
Jun 2021
4:39pm, 21 Jun 2021
15,048 posts
|
NDWDave
Clean up in Column M!
|
Aug 2021
7:12am, 19 Aug 2021
128,753 posts
|
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
|
rf_fozzy
Deathmatches are not there for amusement.
|
Aug 2021
10:21am, 19 Aug 2021
128,767 posts
|
GregP
Indeedles
|
Aug 2021
12:11pm, 27 Aug 2021
128,993 posts
|
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
|
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
|
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
|
GregP
Hm. I think the number of days between next Tuesday and next Wednesday is probably one. Or none. =NETWORKDAYS() returns 2 |
Aug 2021
1:21pm, 27 Aug 2021
35,176 posts
|
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?
|
Aug 2021
1:22pm, 27 Aug 2021
5,076 posts
|
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? |
Related Threads
- Excel skills test Mar 2019
- Accounting Question Oct 2017
- Important excel files deleted - Please Help Oct 2016
- download training log to excel Jan 2024
- Excel boffins - your needed! Sep 2018
- World Cup sweepstake in excel May 2018
- HELP! Excel file corrupted and I need it! Aug 2016
- Running Club Spreadsheet to track PBs Apr 2014
- The Retirement Thread Mar 2024
- What do/would you miss about your job? Feb 2024