using hlookup with sum/choose?
 

I am putting a daily sales report together. At the top of the data page is a
row for the dates (full year), #billing days per month, # billing days in the
quarter, and # billing days per year. I have put a hlookup together on a
seperate tab that takes an input date from the end-user and calculates the
start and end billing day number. Now I am trying to figure out how to
return the Month to date, quarter to date, and year to date sales numbers.
Basically, I need some sort of between statement that will pickup the sales
that fall between the billing dates. Any suggestions?

Example:
Billing day 1 2 3 4 5 6 7 8

Ref table start day: 4
Ref table end day: 7

Thank you.

using hlookup with sum/choose?
 

I am not sure I understand how your excel looks like. However take a look at
the "match" function. I hope this helps

"Stacey" wrote:

I am putting a daily sales report together. At the top of the data page is a
row for the dates (full year), #billing days per month, # billing days in the
quarter, and # billing days per year. I have put a hlookup together on a
seperate tab that takes an input date from the end-user and calculates the
start and end billing day number. Now I am trying to figure out how to
return the Month to date, quarter to date, and year to date sales numbers.
Basically, I need some sort of between statement that will pickup the sales
that fall between the billing dates. Any suggestions?

Example:
Billing day 1 2 3 4 5 6 7 8

Ref table start day: 4
Ref table end day: 7

Thank you.