-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
week of
-
B
Lookup value in table if header date falls within this range
I need to compile a list of item qtys across a weekly grid for reporting purposes. My original sheet is a list with duplicates. How do I arrive at the conclusion in the second table using formulas? Right now I'm doing this manually. <tbody> ITEM QTY SHIPPED IN-HOUSE DATE (OR EST) WEEK...- B5rocksass
- Thread
- compile date range lookup week of
- Replies: 2
- Forum: Excel Questions
-
J
Date formula referencing another cell
I have a spreadsheet where I have dates in Column b and numbers in column F. I would like to reference the cell in column F that is in the same row of the corresponding date that is within this week in column B. I have tried VLOOKUP but cannot produce a formula based on date within the current week.- jmurphyamodeo
- Thread
- if function today vlookup week of
- Replies: 3
- Forum: Excel Questions
-
B
Week of Month Range Formula
Hi Everyone, I'm hoping I can get assistance with this formula I'm trying to figure out. I have in the spreadsheet I'm working on a date in R2 of 01/20/2014. I would like to have it show in JC2 that the date that is in R2 is within the Week of 01/19 - 01/25. Also, if the value of R2 was for...- bcurtis208
- Thread
- formula week of
- Replies: 5
- Forum: Excel Questions
