Day Of Week

[TAGORTI]

Hello,

I want to count the number of weekends between two dates.

Do you have a solution for this demand ?

Thanks a lot

[anirudh]

Hi,

Try this:

ROUND(('Date 2' - 'Date 1') / 7)

Regards,

Anirudh

[rob_marshall · Accepted solution]

@TAGORTI ,

See if this works for you...

Create a SYS Time module by Day with the following line items:

Date: start()

Day Nbr of Week: WEEKDAY(Date)

Count Saturdays: IF Day Nbr of Week <> 6 THEN 0 ELSE 1

In another module that is not dimensionalized by Time, you have 3 line items:

Date1: date formatted that is entered

Date2:date formatted that is entered

Number of Weekends:TIMESUM('SYS Time Filter - Day'.Count Saturdays, 'Date 2', 'Date 1')

Hope this works for you,

Rob

[TAGORTI]

@rob_marshall 

Thanks a lot.

It worked for me, I did some modifications. It fits my need.

Regards,

[TAGORTI]

Thanks for your response.
I was asking about weekends
Regards