CODEWITHSUNDEEP
google-sheetscountifunique-values
Glaucco
Glaucco

Reputation: 47

What is causing the error in the formula =NETWORKDAYS.INTL(JANEIRO!A2;C2;"1";FEVEREIRO!A2;C2;"1") to count only Mondays, and how can it be fixed?

When using the formula =NETWORKDAYS.INTL(JANEIRO!A2;C2;"1";FEVEREIRO!A2;C2;"1") to count only Mondays in the January and February columns A and C sheets, I'm encountering an error. What is causing this error, and how can I modify the formula to correctly count only Mondays within the specified date range? Are there any formatting or syntax requirements that need to be met when using the NETWORKDAYS.INTL function?

I only want to count Monday from the JANUARY, FEBRUARY, columns A and C sheets. But it is giving error in the formula:

= NETWORKDAYS.INTL (JANEIRO! A2; C2, "1"; FEVEREIRO! A2; C2, "1 ") enter image description here

enter image description here

enter image description here

Upvotes: 0

Views: 116

Answers (1)

Glaucco
Glaucco

Reputation: 47

can you help me? I made the change to the question and the image to make it easier to understand

Upvotes: 0

Related Questions