G
Guest
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.
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.