Hi
I am trying to use networkdays() function but after I entered the second date, I got serveral options like [date], [year], [month] etc. please see the attached screenshot. What are these options and why they do not work? Thank you very much.
Hi @lastnn30 ,
in the function NETWORKDAYS the third and forth parameter are optional. Why do you use the dot after [Date2] and not the comma? If you use the comma you should see the correct syntax that is:
NETWORKDAYS(<start_date>,<end_date> [,<weekend>] [,<holidays>])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @lastnn30 ,
in the function NETWORKDAYS the third and forth parameter are optional. Why do you use the dot after [Date2] and not the comma? If you use the comma you should see the correct syntax that is:
NETWORKDAYS(<start_date>,<end_date> [,<weekend>] [,<holidays>])
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
