formulae to calculate nth business day for current month

Gaurav Chauhan

Hi Team,

Which formuale would work best if I need to calculate the nth business day of the current month as of today.

Eg; If today is 6th of Feb, then it is 4th business day

Lets say for next month on 10th of Mar, it would be 8th business day

Can you please help.

Find more posts tagged with

Accepted answers

All comments

Samuel Mueller

@Gaurav Chauhan try a formula like this

=networkdays(date(year(today()), month(today()),1), today())

Also the today() formula only updates if you open the sheet and save, so refer to this article if you need it to update on it's own

Automatically update the TODAY function in formulas | Smartsheet Learning Center

Gaurav Chauhan

Thank you @Samuel Mueller :

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.