turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- Calculate number of weekdays between two days

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

3 weeks ago

Hi all,

I am looking for a way to find the number of weekdays between the first day of the month and a given date.

I've calculated the number of days like in the screenshot, but I can't find a way to take only weekdays into account.

I know I can find the day of the week via the DayOfWeek function, but couldn't find a way to incorporate this in the formula above.

Basically I need to see the number of weekdays elapsed on a given date compared to the start of that month.

I'd appreciate it if anyone could help me with this.

Thanks in advance,

Bas

Accepted Solutions

Solution

3 weeks ago

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Basl

3 weeks ago

All Replies

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Basl

3 weeks ago

Are you looking for a Point&Click answer in VA or a simple code answer?

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to draycut

3 weeks ago

One or the other. That doesn't really matter. I am somewhat familiar with the coding used in VA.

I have only got access to VA 7.4, so if it works there, that would be great.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Basl

3 weeks ago

The INTNX function is available in CAS.

In Base SAS that would be:

`intnx('weekday', date1, date2)`

Solution

3 weeks ago

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Basl

3 weeks ago

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to SASKiwi

3 weeks ago

Thank you all for your replies. I think the suggestion given by SASKiwi should be the easiest way for us.

We'll add the extra column to the data, so we can use it for our calculations instead of trying to build it all in the VA interface.

Thanks!

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Basl

3 weeks ago

Hi @Basl,

I'm glad you found some useful info! If @SASKiwi's reply was the exact solution to your problem, can you "Accept it as a solution"? Or if it was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!

Anna