Date: 21/10/2021 08:34:06
From: Thomo
ID: 1806280
Subject: Excel Q

Hey all need some help.
To get the number of working days from today (or what ever) to another date , I use :
=(NETWORKDAYS)
I’m trying to get a date from today (or what ever) whilst adding X amount of working days .
Any clues ?

Thanks in advance

Brett

Reply Quote
Date: 21/10/2021 08:35:00
From: Thomo
ID: 1806281
Subject: re: Excel Q

=(NETWORKDAYS)

Reply Quote
Date: 21/10/2021 08:36:37
From: Thomo
ID: 1806282
Subject: re: Excel Q

Forula not showing on posts will try again.

=(NETWORKDAYS)

Reply Quote
Date: 21/10/2021 08:37:30
From: Thomo
ID: 1806283
Subject: re: Excel Q

(NETWORKDAYS)

Reply Quote
Date: 21/10/2021 08:38:05
From: Thomo
ID: 1806284
Subject: re: Excel Q

FU%% !

Reply Quote
Date: 21/10/2021 08:39:23
From: roughbarked
ID: 1806285
Subject: re: Excel Q

Thomo said:


FU%% !

Saw that one. :)

Reply Quote
Date: 21/10/2021 08:39:58
From: Thomo
ID: 1806286
Subject: re: Excel Q

=(NETWORKDAYS)

equals bracket “networkdays” bracket cell comma cell bracket bracket

Reply Quote
Date: 21/10/2021 08:44:56
From: Thomo
ID: 1806288
Subject: re: Excel Q

Ah ha

=WORKDAY

Reply Quote
Date: 21/10/2021 08:45:07
From: btm
ID: 1806289
Subject: re: Excel Q

Thomo said:


=(NETWORKDAYS)

equals bracket “networkdays” bracket cell comma cell bracket bracket

=(NETWORKDAYS($F$46,F49))

Reply Quote
Date: 21/10/2021 08:46:35
From: Thomo
ID: 1806290
Subject: re: Excel Q

Thomo said:


Ah ha

=WORKDAY


equals “workday” bracket cell comma cell bracket

Reply Quote
Date: 21/10/2021 08:47:36
From: Thomo
ID: 1806291
Subject: re: Excel Q

btm said:


Thomo said:

=(NETWORKDAYS)

equals bracket “networkdays” bracket cell comma cell bracket bracket

=(NETWORKDAYS($F$46,F49))

@ before and after ?

Reply Quote
Date: 21/10/2021 08:48:24
From: Thomo
ID: 1806293
Subject: re: Excel Q

=WORKDAY(F46,C44)

Reply Quote
Date: 21/10/2021 08:48:55
From: Thomo
ID: 1806294
Subject: re: Excel Q

Works , thanks btm

Brett

Reply Quote
Date: 21/10/2021 08:49:01
From: btm
ID: 1806295
Subject: re: Excel Q

Thomo said:


btm said:

Thomo said:

=(NETWORKDAYS)

equals bracket “networkdays” bracket cell comma cell bracket bracket

=(NETWORKDAYS($F$46,F49))

@ before and after ?

Yep. Anything between @s is displayed (on this forum) literally.

Reply Quote
Date: 21/10/2021 08:51:37
From: roughbarked
ID: 1806296
Subject: re: Excel Q

btm said:


Thomo said:

btm said:

=(NETWORKDAYS($F$46,F49))

@ before and after ?

Yep. Anything between @s is displayed (on this forum) literally.

Cool.

Reply Quote
Date: 21/10/2021 09:39:51
From: SCIENCE
ID: 1806307
Subject: re: Excel Q

use == to wrap code you want to literally deliver

Reply Quote
Date: 21/10/2021 09:42:58
From: The Rev Dodgson
ID: 1806309
Subject: re: Excel Q

SCIENCE said:


use == to wrap code you want to literally deliver

Not @?

Or do they both work?

The quick reference down there only mentions @.

Reply Quote
Date: 21/10/2021 10:44:38
From: SCIENCE
ID: 1806331
Subject: re: Excel Q

The Rev Dodgson said:

SCIENCE said:

use == to wrap code you want to literally deliver

Not @?

Or do they both work?

The quick reference down there only mentions @.

@@

@[test]@

uh not good

Reply Quote
Date: 21/10/2021 11:16:13
From: The Rev Dodgson
ID: 1806342
Subject: re: Excel Q

SCIENCE said:


The Rev Dodgson said:

SCIENCE said:

use == to wrap code you want to literally deliver

Not @?

Or do they both work?

The quick reference down there only mentions @.

@@

@[test]@

uh not good

So neither works?

Reply Quote
Date: 21/10/2021 12:22:49
From: SCIENCE
ID: 1806358
Subject: re: Excel Q

The Rev Dodgson said:


SCIENCE said:

The Rev Dodgson said:

Not @?

Or do they both work?

The quick reference down there only mentions @.

@@

@[test]@

uh not good

So neither works?

not properly which is why we use [ and ] to entitise them

Reply Quote
Date: 21/10/2021 12:27:20
From: Cymek
ID: 1806359
Subject: re: Excel Q

Do air conditioners use a lot of copper piping, in this case an industrial unit, bit of a vague question I know

Reply Quote
Date: 21/10/2021 12:30:10
From: Cymek
ID: 1806362
Subject: re: Excel Q

Cymek said:


Do air conditioners use a lot of copper piping, in this case an industrial unit, bit of a vague question I know

Sorry

Reply Quote
Date: 21/10/2021 15:35:58
From: SCIENCE
ID: 1806443
Subject: re: Excel Q

Cymek said:

Cymek said:

Do air conditioners use a lot of copper piping, in this case an industrial unit, bit of a vague question I know

Sorry

not ours but possibly The Rev Dodgson’s

Reply Quote
Date: 21/10/2021 15:42:13
From: Cymek
ID: 1806444
Subject: re: Excel Q

SCIENCE said:


Cymek said:

Cymek said:

Do air conditioners use a lot of copper piping, in this case an industrial unit, bit of a vague question I know

Sorry

not ours but possibly The Rev Dodgson’s

I was wondering as an offender dismantled an air conditioning unit at a small industrial factory to steal the copper.
Caused $33000 of damage, told to pay for the damages and I was wondering how much he got for the copper (that’s assuming he got any)
I had a quick look at copper pipping is worth about $7 a kilo, no way he got anything close to even breaking even

Reply Quote
Date: 21/10/2021 19:02:23
From: mollwollfumble
ID: 1806510
Subject: re: Excel Q

SCIENCE said:


Cymek said:

Cymek said:

Do air conditioners use a lot of copper piping, in this case an industrial unit, bit of a vague question I know

Sorry

not ours but possibly The Rev Dodgson’s

Yes!

Reply Quote