Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
125 views
in Technique[技术] by (71.8m points)

javascript - Is there a workday equivalent googlescript function

Is there a way to find the nth workday from the current month. I know that google sheet have a function WORKDAY.INTL to get the date of the workday specified in the parameters

=WORKDAY.INTL(start_date, days, [weekend],[holidays])

is there a way to write a google script function that does the same function as the above formula. For example, to find the 3rd workday date of the current month.

question from:https://stackoverflow.com/questions/66045553/is-there-a-workday-equivalent-googlescript-function

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Adding what Marios said in the comments but as an answer so it has more visibility.

Google Apps Script does not have such utility. The way of doing it is using JavaScript. There is already some answers in the JavaScript tag (for example this one).


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...