I would like to give the user the option to choose between DAYS360() and NETWORKDAYS().
For that, I thought about adding these 2 to a data validation cell.

Afterwards, I would like to be able to add that choice as part of a new formula that calculates the worked days as such:


Can that be accomplished within Google Sheets without scripts?
I've tried myself some formulas, but couldn't get to any solution.

1 Answer 1


Create a drop-down list with the values elapsed calendar days and working days in cell A12. Then use this formula:

  A12 = "elapsed calendar days", days360(D12, E12), 
  A12 = "working days", networkdays(D12, E12), 
  true, iferror(1/0) 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.