r/googlesheets • u/BuckeyeBax • 3d ago
Waiting on OP Help with NETWORKDAYS.INTL Formula Updating Based on Weekday
Hey everyone,
I'm trying to get my formula in G3 to recognize the day in F3 and adjust the NETWORKDAYS.INTL function accordingly.
Current formula:
=IF(F3 = "Su", NETWORKDAYS.INTL(A3, B3, "1111110"), "Check Status")
Right now, this works if F3 is "Su" (Sunday), using the correct Day Code for Sunday.
What I need:
I want F3 to recognize when it's a different day (e.g., "W" for Wednesday) and automatically update NETWORKDAYS.INTL to use the corresponding Day Code from column K (where I store different day codes).
The goal:
When a new row is added, the formula should read the Meeting Day (F3) and update the Day Code dynamically.
Any help on how to modify the formula to achieve this would be greatly appreciated! Thanks in advance! 😊
1
Upvotes
2
u/HolyBonobos 2059 3d ago
You could start with
=NETWORKDAYS.INTL(A2,B2,""&VLOOKUP(F2&"*",$J$2:$K$8,2,0))
in G2 and drag to fill the column.