¿How to count Saturdays in date range?

[#1]

Hi there,

I need your help to solve my issue, i need to count saturdays in date range:

I have a field with date (Format: DD/MM/YYYY hh:mm:ss) and i make filters in diferents range but i need only count how many saturdays exist into this range selected (the range is variable).

Thanks for all!.

Thanks in advance.

[swuehl]

Not sure what your list boxes are showing. Have you selected a single week in the middle list box?

[#3]

Yes, the green color is current selection. I select Week 17 and 18,19,20,21 and 22 of April.

[swuehl]

Well, could you upload your current sample file?

edit:

Are you using a different week start / week numbering compared to ISO?

[#5]

The file is uploaded in the main post.

[swuehl]

Can't see an attached file.

[#7]

Check again, pls.

[swuehl · Accepted solution]

You have changed the system variable FirstWeekDay, which influences Weekday() function.

You can correct this like

Div(WEEKDAY(Min([Creation Time])-6,0)+1-Min([Creation Time])+Max([Creation Time]),7)

[#9]

Thanks you!

The problem its solved.