Hi,

I want to somehow pull through sales data for between two dates. I have the
dates as 3/1/08 and the sales data has come through by week. How could i
pull through the info for between two dates?

EG : sales data looks like this

Week 1 3000
Week 2 5000

But the dates i need are between 1.1.08 and 18.2.08 for specific products.

I was planning on doing lookups to get the product, somehow linking to dates
(Concatenate) but then i was lost in how to get sales BETWEEN two dates....

Any thoughts out there?

Look for week numbers greate than X and less then Y. Don't use dates. The
formula below will get the week numbers out of your data by using the MID
function

=IF(AND(VALUE(MID(A1,6,2))=1,VALUE(MID(A1,6,2))<= 2),TRUE,FALSE)

"Owl" wrote:

Hi,

I want to somehow pull through sales data for between two dates. I have the
dates as 3/1/08 and the sales data has come through by week. How could i
pull through the info for between two dates?

EG : sales data looks like this

Week 1 3000
Week 2 5000

But the dates i need are between 1.1.08 and 18.2.08 for specific products.

I was planning on doing lookups to get the product, somehow linking to dates
(Concatenate) but then i was lost in how to get sales BETWEEN two dates....

Any thoughts out there?

Hi Joel,

Thanks for this - are you saying apply this formula to 10/8/08 and it will
summarise it somehow?

My weeks look like this

10/01/2008 10/01/2008

Sales look like this - via a pivot - and the weeks go 1,2,3,4 then 1,2,3,4
rather than 1-52


Month Week Number
01-08
Description 1 2 3
x 937.6 908.67 968.04



"Joel" wrote:

Look for week numbers greate than X and less then Y. Don't use dates. The
formula below will get the week numbers out of your data by using the MID
function

=IF(AND(VALUE(MID(A1,6,2))=1,VALUE(MID(A1,6,2))<= 2),TRUE,FALSE)

"Owl" wrote:

Hi,

I want to somehow pull through sales data for between two dates. I have the
dates as 3/1/08 and the sales data has come through by week. How could i
pull through the info for between two dates?

EG : sales data looks like this

Week 1 3000
Week 2 5000

But the dates i need are between 1.1.08 and 18.2.08 for specific products.

I was planning on doing lookups to get the product, somehow linking to dates
(Concatenate) but then i was lost in how to get sales BETWEEN two dates....

Any thoughts out there?

You will need to convert the date to a week number. There are plenty of
request at this website for conversion from a date to a week number (do a
search). I can help with the conversion but not sure how your week numbers
work. do they start on the first sunday of the month or start on saturday.
Week numbers vary from company to company. The function WeekNum() may work.

"Owl" wrote:

Hi Joel,

Thanks for this - are you saying apply this formula to 10/8/08 and it will
summarise it somehow?

My weeks look like this

10/01/2008 10/01/2008

Sales look like this - via a pivot - and the weeks go 1,2,3,4 then 1,2,3,4
rather than 1-52


Month Week Number
01-08
Description 1 2 3
x 937.6 908.67 968.04



"Joel" wrote:

Look for week numbers greate than X and less then Y. Don't use dates. The
formula below will get the week numbers out of your data by using the MID
function

=IF(AND(VALUE(MID(A1,6,2))=1,VALUE(MID(A1,6,2))<= 2),TRUE,FALSE)

"Owl" wrote:

Hi,

I want to somehow pull through sales data for between two dates. I have the
dates as 3/1/08 and the sales data has come through by week. How could i
pull through the info for between two dates?

EG : sales data looks like this

Week 1 3000
Week 2 5000

But the dates i need are between 1.1.08 and 18.2.08 for specific products.

I was planning on doing lookups to get the product, somehow linking to dates
(Concatenate) but then i was lost in how to get sales BETWEEN two dates....

Any thoughts out there?

Hi Joel,

I finally converted the weeks to week number and am now trying to link this
to my other file


Week Number

ID Code 1 2 3 4

9781405230278 826.62 682.86 634.94
1405217367 299.25 379.05 359.10

So, for example, how would i sum up weeks 2 and 3 only? Would it be sumif
on week 3 less sumif week 1. And if i used the < formula, how would i
ensure i dont double count if its for week 2 only?





"Joel" wrote:

You will need to convert the date to a week number. There are plenty of
request at this website for conversion from a date to a week number (do a
search). I can help with the conversion but not sure how your week numbers
work. do they start on the first sunday of the month or start on saturday.
Week numbers vary from company to company. The function WeekNum() may work.

"Owl" wrote:

Hi Joel,

Thanks for this - are you saying apply this formula to 10/8/08 and it will
summarise it somehow?

My weeks look like this

10/01/2008 10/01/2008

Sales look like this - via a pivot - and the weeks go 1,2,3,4 then 1,2,3,4
rather than 1-52


Month Week Number
01-08
Description 1 2 3
x 937.6 908.67 968.04



"Joel" wrote:

Look for week numbers greate than X and less then Y. Don't use dates. The
formula below will get the week numbers out of your data by using the MID
function

=IF(AND(VALUE(MID(A1,6,2))=1,VALUE(MID(A1,6,2))<= 2),TRUE,FALSE)

"Owl" wrote:

Hi,

I want to somehow pull through sales data for between two dates. I have the
dates as 3/1/08 and the sales data has come through by week. How could i
pull through the info for between two dates?

EG : sales data looks like this

Week 1 3000
Week 2 5000

But the dates i need are between 1.1.08 and 18.2.08 for specific products.

I was planning on doing lookups to get the product, somehow linking to dates
(Concatenate) but then i was lost in how to get sales BETWEEN two dates....

Any thoughts out there?

I would sum each column (my example in row 25) and use sumproduct. If you
have 52 weeks which would be columns B to BZ. Then the following formula can
be used


=SUMPRODUCT(--(B1:BZ1=2),--(B1:BZ1<=3),B25:BZ25)

"Owl" wrote:

Hi Joel,

I finally converted the weeks to week number and am now trying to link this
to my other file


Week Number

ID Code 1 2 3 4

9781405230278 826.62 682.86 634.94
1405217367 299.25 379.05 359.10

So, for example, how would i sum up weeks 2 and 3 only? Would it be sumif
on week 3 less sumif week 1. And if i used the < formula, how would i
ensure i dont double count if its for week 2 only?





"Joel" wrote:

You will need to convert the date to a week number. There are plenty of
request at this website for conversion from a date to a week number (do a
search). I can help with the conversion but not sure how your week numbers
work. do they start on the first sunday of the month or start on saturday.
Week numbers vary from company to company. The function WeekNum() may work.

"Owl" wrote:

Hi Joel,

Thanks for this - are you saying apply this formula to 10/8/08 and it will
summarise it somehow?

My weeks look like this

10/01/2008 10/01/2008

Sales look like this - via a pivot - and the weeks go 1,2,3,4 then 1,2,3,4
rather than 1-52


Month Week Number
01-08
Description 1 2 3
x 937.6 908.67 968.04



"Joel" wrote:

Look for week numbers greate than X and less then Y. Don't use dates. The
formula below will get the week numbers out of your data by using the MID
function

=IF(AND(VALUE(MID(A1,6,2))=1,VALUE(MID(A1,6,2))<= 2),TRUE,FALSE)

"Owl" wrote:

Hi,

I want to somehow pull through sales data for between two dates. I have the
dates as 3/1/08 and the sales data has come through by week. How could i
pull through the info for between two dates?

EG : sales data looks like this

Week 1 3000
Week 2 5000

But the dates i need are between 1.1.08 and 18.2.08 for specific products.

I was planning on doing lookups to get the product, somehow linking to dates
(Concatenate) but then i was lost in how to get sales BETWEEN two dates....

Any thoughts out there?