Dates

J

Jean-Francois

Hi all,

I have a table table with the following entries:

ID Date
1 01-Aug-03
2 05-Aug-03
3 18-Aug-03

What would be the best way to calculate the "working"
days between any two dates? If I wanted to calculate an
average time spent, what would be the best function?

Thank you very much,
Jean-Francois
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting AD and/or BC dates 21
Problem formatting dates from CSV file 2
Running Balance (Debit and Credit) in Access 2007 3
Formula to fill cells based on Date of Arrival and Date of Departure 1
Macro to send email 5 days before a date mentioned in Cell 1
SQL query help 6
Creating a "grid" of data 3
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top