Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to find no of Odd saturdays between two dates

Hi Guys i just wanted to find no of Odd Saturdays between two given dates.

2 Replies
rittermd
Master
Master

There is a Even function that you could possible use on the day portion of the date. 

If it is Odd then the value returned by this expression is 0.

I personally have never used this.  But it seems straightforward enough.

There are also functions to determine the day of the week to pick out just Saturdays.

Hopefully that will send you down the right path.

Anonymous
Not applicable
Author

Thanks for your response Mark

But there are possibilities that an odd Saturday(1st,3rd,5th saturday) can come on even day(even Date of month) so that logic won't work.

Any other approach would be appreciated