Windows Forum

Ask something
Discussion Locked

Access/Excel query

0 helpful
5 replies

by edmond_sng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to run a Query on Access or create formula in Excel which will calculate Length of Time for Response:

Deadline: 01/04/02
Response: 05/04/02

Length of Time for response: 5 days

What criteria will I need to set in Access or if I analyze it with Excel - what formula would I use to calulate this? The format of the dates are set as above.

Thanks for your help. This will help me to write up a report.

5 replies

by smmurphy

In Excel, there is a formula called DAYS360 in the Date & Time function catagory that will give you elapsed days between 2 dates. The only drawback is that it uses 12 30 day months for a total of 360 days/year instead of the standard calendar.

I'm not aware of this calculation in Access.

This discussion is closed to new replies.