Hi,

I need to calculate the difference betwen two dates. without the weekend (Saturday and Sunday) to display the actual "Work" days.

Anybody knows how to do this ?

Thanx.

You can use the DAYS360 function.. but this is not exactly what you want..

Rhys

Forget the above, http://office.microsoft.com/en-gb/as...1033.aspx]This is what you want :)

create a table (i called it pivot_table), and in that, put a single column, populating it with a row for every day that might exist between your day range (I only populated 1-366)
So: pivot_table
field: Counter, Number
values: 1 through 366

select count(*)
from pivot_table
where counter <= [end_date] - [start_date] + 1
and weekday([start_date]+counter-1) not in (1,7) /* Sun,Sat */
and [start_date]+counter-1 /* a day */
not in
(select Holiday_Date
   from holidays )

This concept comes from asktom.oracle.com, converted to Access.

Jos,
This is what I have:
1) start field as date
2) end field as date

On the start and end field,
you can calculate what day of the week it is by:
3) num1_start = Format([start], "w")
4) num2_end = Format([end], "w")

Then calculate to exclude weekends as follows:
5) day_num1 = IIf(num1_start]]>6,0,[num1_start]-1)
6) day_num2 = IIf(num2_end]]>6,0,[num2_end]-1)

con't...
7) days_worked_on_start_week =
IIf([day_num1]=0,0,DatePart("w",6-[day_num1]))

8) days_worked_on_end_week =
IIf([day_num2]=0,5,DatePart("w",[day_num2]))

9) days_worked_without_startweek_and_endweek =
((DateDiff("ww",[start],[end])-1)*5)

10) total_num_of_days_worked =
    [7]++[9]

It should work.
john

simplicity is beauty...