In today’s NetSuite guide, we will share a saved search showcasing how to get the number of weekdays in a given month. This saved search can help in determining how many weekdays in a month.
How to Calculate Weekdays in a Month
Sample Use Case:
This NetSuite saved search is beneficial for companies operating on weekdays only, and want to see their monthly sales in a more concise manner – a daily sales report. The desired formula is to divide the sales quantity/amount by the number of days they are operational in a given month.
How to build the Saved Search
1. Create a Transaction Saved Search with the following Standard Criteria:
- Type = is Sales Order
- Main Line = is true
- (Optional) Date = use this to limit the data you want to see. E.g., “within this year.”
2. Set the following in the Results tab:
| Field | Summary Type | Function | Formula | Summary Label |
| Date | Group | Month | Month | |
| Amount | Sum | Amount | ||
| Formula (Numeric) | Group | to_char(last_day(trunc({trandate})),’DD’)-((trunc(last_day({trandate}),’IW’)-trunc(trunc({trandate},’MONTH’),’IW’))/7*2)-(decode(to_char(last_day(trunc({trandate})),’D’),1,2,7,1,0))+(decode(to_char(trunc({trandate},’MONTH’),’D’),1,1,0)) | No. of Days | |
| Formula (Currency) | Sum | {amount}/(to_char(last_day(trunc({trandate})),’DD’)-((trunc(last_day({trandate}),’IW’)-trunc(trunc({trandate},’MONTH’),’IW’))/7*2)-(decode(to_char(last_day(trunc({trandate})),’D’),1,2,7,1,0))+(decode(to_char(trunc({trandate},’MONTH’),’D’),1,1,0))) | Sales per Day |
Note: You may add additional fields that you want to see whenever you drill down on the Saved Search.
Wrapping Up
As a highly accredited NetSuite Solution Provider, ScaleNorth is well-positioned to help you with the full scope of your NetSuite customization needs. If you require more NetSuite assistance, contact ScaleNorth today.
Check out more Suite Guides:
- How to Use Undeposited Funds in NetSuite
- How to View Invoices in NetSuite
- How to Bypass Location Limits in NetSuite
About the Author
Kouji is a seasoned professional in NetSuite Consulting. He brings a wealth of experience as an Ex-Director of Customer Support at NetSuite and Airbase. A Certified Public Accountant, his unique blend of financial expertise and technical savvy enables him to navigate complex challenges and provide innovative solutions. With a track record of leadership and a deep understanding of NetSuite intricacies, Kouji delivers seamless customer support strategies.