Forum Discussion
Post Patronnetworkingdays with [Year] option
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.
1 Reply
- mangaus1111
Solution Sage
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.