calculations between days

[Bill]

Hello everybody

I have a problem of customer service report and i need to
solve a problem but i do not know if there is such a
formula.

I have two dates. One is the requested day 23/01/2004
(E50), and the second one is the Delivery day 10/05/2004
(Z5). I want to express the difference between the two
days, but i want to see the result as a week number.

There is any possibility to change the days to week
number?

Also in Column E i have the requested days (day format)
In the row 5 from column k to bb i have the days of
delivery (days format). In the area table i have the
orders.
there is any way that i can calculate orders that have
been by delay less than 7 days, between 7 to 15 days and
more than 15 days?
If there is anyone to help me i can send him a more clear
example to check it.

Regards Bill

 

[Norman Harker]

Hi Bill!

First define your week number system.

See:
http://www.cpearson.com/excel/weeknum.htm

For counting orders based on the delay you can use COUNTIF. For
greater than 7 and less than or equal to 15 you can use COUNTIF for
greater than or equal to 7 and deduct COUNTIF for greater than 15.

 

[JMay]

There is an "undocumented" datedif() function;
example:

=INT(DATEDIF(B4,B6,"d")/7)
where b4 = request date
and b6 = delivery date

function above will return the number of full-weeks that have passed
without regard to holidays,wekkends, etc..

HTH
JMay