English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories
0 ⤊

Microsoft Access?

What is the formula for calculating the difference between two date fields, excluding saturdays and sundays?

2006-07-13 06:52:41 · 1 answers · asked by Christian M 2 in Computers & Internet ➔ Software

1 answers

Find the number of days between two dates.
Then subtract the numbers of weeks times 2

Example : let the number between two dates be 22

then int(22/7)=3
3*2=6
22-6=16

2006-07-13 07:46:55 · answer #1 · answered by iyiogrenci 6 · 0⤊ 0⤋

fedest.com, questions and answers