between 2 dates

  1. larinda4

    FORMULA HELP! (SUM between two cells)

    I've been racking my brain trying to figure out a formula for this. I've included borders to help illustrate what I need. I'm trying to sum column P based on the month in Q and subtract it from the debited amount in column S to get my monthly total in column T. I tried doing a SUMIF but as...
  2. K

    IF + AND + VLOOKUP Formula

    Hello, First time post, long time user here so please be kind if I don't follow correct protocol. I am creating a forecast budget and need to amend to below formula to include a VLOOKUP parameter. My current formula works to produce the $ value from A2 if the date in B2 falls between the...
  3. B

    Searching for holidays within a range in between dates listed in 2 cells

    Hello, This is my first post. Thanks for your time to read this. I have an entry and an exit date for a reservation in 2 cells and in another worksheet I have a range of holidays listed in a column. I want to find the holidays within the dates in between the 2 cells and also know if they are...
  4. J

    2013 Power Pivot - Calculate Workdays Between Date - Insert Date When 1 Date Missing

    Afternoon, I'm really hoping someone can assist with the formula/calculation to insert a date when one date is missing between the two dates I'm trying to basis the calculation on. My table [fCompletedPRs] contains information related to procurement requisitions submitted and worked in our...
  5. K

    Return multiple values from another table if cell is within next 1.5 years

    Hi all, This is my first time posting so apologies if i don't know the lingo! I have a property register set up as a table. Some properties have lease expiries (however this field is blank for a lot of properties), on a separate tab I want it to display each row with an expiry coming up within...
  6. D

    Returning a text value from a multi criteria lookup using an exact match and between statement

    Hi All, I'll do my best to explain my issue. It's a similar problem to threads that I have seen resolved, but none seem to fit my problem... (I've included some context at the bottom of the post) Essentially, I need to perform a 3 (or 2) way lookup and return a result from a field on the data...
  7. K

    Conditional Format for ANOTHER column that contains ANYTHING

    I'm trying to figure out a formula that will conditionally format another column than itself. Ex. I would like the conditionally formatted column to be column O but search column L for cells that contains a date between columns K and M. Columns K and M are start and end dates. The Between...
  8. A

    Add a Date Range to a Select Distinct Query

    I am having trouble figuring this out. I have a SELECT DISTINCT query, which is working fine. In the table that the query is based on, there is a Date Column. I would like to add BETWEEN DATE RANGE criteria to this query, but I have been unable to do so. If I add the date column to the query...
  9. C

    Errors in SELECT query from Excel to Access

    I'm trying to produce an Excel workbook which connects to my access database and extracts values from a table based on whether those records have a Request_Date between two strings. The code I have written works fine if I substitute the strings for actual dates however when I then try to...
  10. G

    Sort Pivot Table for Data Between Two Dates

    I am working with some poorly designed data... the query return two columns (a start date and an end date). I need to be able to select a date and see which projects were active at that time. Ideally I would like to be able to do this in a pivot table but I am also open to other solutions so...
  11. R

    Days between excluding Chinese New Year

    Hi This is my first post on this forum. I am trying to write a formula for working out the date for when to place an order. The criteria is a delivery date (Cell A1) and production lead time (Cell B1). Therefore a1-b1. Simple, why am I asking help with this! ......However, I need to exclude...
  12. D

    Look up a date in a table with a list of multiple start and dates and return a default value if found

    Hi All, I am having some trouble trying to create a query that will return a default value if the date being looked up falls between any of the start and end times in another table. The date being looked up is in table1 and start and end dates are in table2. I need for the value in table 1 to...
  13. R

    Auto Populate Data between dates

    Hello, I have a unique question. I am trying to auto populate data (resource needs) between two dates in excel. For instance, each month from January 2015 (start month) to December 2017 (end month) I need 5 resources. Jan 2015=5 resources, Feb 2015=5 resources, and so on all the way to...
  14. G

    Need to return a date if another specified date is between two dates in a table

    Hi I need to return a date if another specified date is between two dates in a table. I am using Excel 2010. An example is: Due Date Start Date End Date InvoiceDate 24 Dec 2014 18 Dec 2014 25 Dec 2014 22 Dec 2014 31 Dec 2014 25 Dec 2014...
  15. J

    Resource Availability Tracker Index Matching

    Hi There, I am trying to create a resource availability file in Excel. I have input data such as the following: <colgroup><col><col span="2"><col></colgroup><tbody> Type Start Date End Date Person A Holiday 01/05/2015 02/05/2015 Person B Training 30/04/2014 03/05/2015 Person B Holiday...
  16. Fishboy

    Complicated SUMPRODUCT of multiple items between 2 dates

    Hi all, In Excel 2010 I am trying to work out a number of different items sold on a specific date. To make things more complicated, the items being sold sell in differing sized stacks and for different sale values each time. As a result the formula needs to look at "Item Value" from one...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top