
Creator III
2022-05-05
11:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Networkdays Question
Hi - I have a question about the Networkdays function.
I presently have the following in my dataload:
Today(1) - Date(Date#(abcddate,'YYYYMMDD'),'MMDDYYYY') as NumberofDays
Works perfectly BUT I want to remove Saturday/Sunday from the calculation.
Give the current format above of the date fields, what is the best way to approach this with the Networkdays function?
Thanks - Jerry
477 Views
1 Solution
Accepted Solutions

Master II
2022-05-09
10:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should try something like
Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays
421 Views
1 Reply

Master II
2022-05-09
10:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should try something like
Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays
422 Views
