Calculate Working Days between two dates with conditions

[mba_110]

Hi and hello everyone there,

I need the following diffdate expression formula in MS access 2010 this is to calculate total working days between two dates.

I have two methods in my Access table to produce the result with total number of working days.

I have columns [Leave_Start] and [Leave_End] and result column is [Total_Wdays]

First Method
1. First method is to calculate number of working days between these [Leave_Start] and [Leave_End] dates but their is one twist during this calculation weekends (Holidays) should be Thursday & Fridays but from 29/06/13 the weekend (Holiday) should be Friday & Saturdays i know its same two days but it make difference if anyone went on holidays during/after these days.

Second Method
Second method is straight to calculate number of working days between these [Leave_Start] and [Leave_End] dates without any cut off or twist during this calculation weekends (Holidays) should be Friday & Saturdays.

Kindly provide the formula in Access 2010 for above methods.

Thanks & regards,

MBA

 

[xenou]

My solution has been to maintain a table with calendar information. Then it's simply a matter of querying your table (for instance, the number of working days would be simply the sum or count of workdays between the two dates. You could also (at your option) have two different such calendars, or just count the days by day of week excluding the days you don't want to count, whether Fri and Sat or Sat and Sun - whatever seems best.

See my post:
http://www.mrexcel.com/forum/microsoft-access/697052-how-work-out-number-days-month.html#3