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