Forum Discussion

lastnn30's avatar
lastnn30
Icon for Post Patron rankPost Patron
3 years ago
Solved

networkingdays 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 ...
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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.

mangaus1111's avatar
mangaus1111
Icon for Solution Sage rankSolution Sage
3 years ago

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.