Issue networkdays value in google spreadsheet

Question

I have created the formula = NETWORKDAYS.INTL(E84,F84) and E84 and F84 are same date -> 2022.9.5. if it is the same date in both columns, it shows the value 1 but it shows the value 0.

It worked before but now it doesn't work.

https://docs.google.com/spreadsheets/d/1dY6gwDIjjxUPTU-4v0j1MqF1sq7YCgHLTH040QMQrHU/edit?usp=sharing

running =NETWORKDAYS.INTL(TODAY(),TODAY()) shows me 1. can you share a copy/sample of your sheet? — player0
– player0, Commented Sep 6, 2022 at 2:12
=NETWORKDAYS.INTL(TODAY(),TODAY()) returns #ERROR on my side — Cedric Arnould
– Cedric Arnould, Commented Dec 8, 2022 at 16:40

José Luis López Navas · Accepted Answer · 2022-09-07 10:34:19Z

0

There was an issue and now it's working properly. Here are more details.

If you refresh the document, you can reload the function with the fix.

answered Sep 7, 2022 at 10:34

José Luis López Navas

16

Sign up to request clarification or add additional context in comments.

1 Comment

Cedric Arnould Over a year ago

Seems the issue came back, not working today (08/12/2022)

player0 · Accepted Answer · 2022-09-13 08:04:37Z

0

looks like a bug but here is some quick workaround:

=IF(A2=B2; 1; NETWORKDAYS(A2; B2))

edited Sep 13, 2022 at 8:04

answered Sep 6, 2022 at 12:27

player0

131k14 gold badges92 silver badges149 bronze badges

Collectives™ on Stack Overflow

Issue networkdays value in google spreadsheet

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related