Count Sunday & Saturday between two days (1 Viewer)

[kashif.special2005]

Hi

I have table named Date and there is three columns Start_Date, End Date and Count_Sunday_Saturday.

I want to count how may Sunday and Saturday between Date1 and Date2.

date1​

date2​

Except_Sunday_Saturday​

1/1/2012​

1/25/2012​

​

I am not able to do this.

Please help it is very important.

Thanks & Regards,
Kashif.

 

[jzwp22]

The only way that I can think of to do what you want is with a custom function. In the attached database, I have created that function: SatSunCount(). I have also included a query (Query1) that shows how to use it.

As a note, it looks like you want to store the count in the field in your table. As a general rule, calculated values are not stored in tables, but rather calculated on the fly when you need them in queries, forms or reports.

 

[vbaInet]

* You can use the WeekDay function on Start_Date and End_Date, e.g.

Weekday([Start_Date]) IN (1, 7)

* Sum() on this field
* Use the Abs() function to get rid of the minus.

NB: I don't see why you have Count_Sunday_Saturday as a field in your table.

 

[kashif.special2005]

Hi,

Thanks everyone it is working fine

Thanks,
Kashif.