Hi Vivi,

You can calculate the week a date is in by using the following:

=ROUNDUP(( [1] - [2] )/7,0)

whe
1-Your date
2-The numerical value for the 01/01 of the year you are calculating (38718
for 2006)

If you are aiming to report on weekly sales then this should do you just fine.


HTH

Thanks,

Simon



vivi wrote:
Hi there I hope someone could help me

I've got a column of dates in column A and the sales for each date in column B

What I need to do is that I have to classify these daily sales figures into
weekly sales figures downloaded onto my "Sales!" sheet
Then I've created a new sheet "Sheet1!"and put the to and from date in
column A and B and the week number in column C

For example
Date From Date To: Week Number:
01/01/2006 07/01/2006 1
08/01/2006 15/01/2006 2

I would like to do a lookup in my downloaded daily sales figures and I've
put a formula:

If(Sales!A1<Sheet1!B2,if(Sales!A1Sheet!A1,vlooku p(Sales
A1,Sheet!A:C,3,0),"Checking")

However it doesnt work, can somebody please help me and tell me what have I
done wrong and how should I put it right please?

Thanks a lot

Vivi

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1