I'm trying to create a new table of dates of the first and last day of the month.
The date range for this new table is from the "Date Created" field of a separate table (Table 1) which is from an external data source.
I'd like the new table to be dynamic so that as Table 1 is updated, the date...
I've been thinking about this for a few weeks now and can't come up with a workable solution. I've searched for weeks trying to find an answer but I'm officially stumped. Any help would be huge!
Situation: I have a list of names with a start and an end date for performance reports as shown...
Hi everyone,
I have calculated the total number of workdays between two dates by quarter using the formula below:
=MAX(0,NETWORKDAYS(MAX($A2,C$1),MIN($B2,EOMONTH(C$1,2))))
Example:
Start Date
End Date
1/1/2019
4/1/2019
7/1/2019
10/1/2019
1/1/2019
4/30/2019
64
22
0
0
1/1/2019
12/31/2019...
What formula to use, my formula gives a wrong result. =DATE(YEAR(A1),MONTH(A1)+E1,DAY(A1))
Start date of Payment - Jan 05, 2019
Months to Pay - 6 Months
No. of Payments - 12
End Date of Payment Should be - June 20, 2019 but when I use the formula its giving me a result of JULY 5, 2019...
Hi all,
I have an excel sheet that help us calculate hove many days we have on stock for a specific component and return the date we run out of stock. The calculation contains the current stock level, different phase out day for for each product the specific component is a part of and usage per...
Hi
I'm trying to calculate the End Date Time knowing the Duration (in hours:minutes decimal unit) and following a specific schedule.
Example:
Monday: Start work at 7:30 until 9:00
Monday: --Break--
Monday: Start work at 9:15 until 12:00
Monday: --Lunch--
Monday: Start work at 12:30...
Hello. Hoping you can help with this one. I'd like a more automated way to populate my revenue forecast based on the following fields:
Amount
Fee Type
Start Date
End Date
Re' Fee Type: One Time Fees are billed on the start date and include the full amount, regardless of the day it...
I am looking for help re: macro code for the following:
- I have numerous rows of data, each with a start date (column G) and end date (column H)
- I am trying to write a macro that will populate all dates between, including start date, across each row, beginning at column L and populating to...
Hi there,
I have a spreadsheet with dates on the first row, and below if we are working that date we put a "1". I am looking for a formula that can tell me the start date and the end date based off whether the cell is populated.
Any help would be great!! THANKS!!
Hello everyone!
I have tried Googling and searching this forum for this answer to no avail so I was hoping that someone could help me figure this one out since I can't seem to do so.
I am trying to figure out the following.
I have a start date for a few events happening during a week. Lets...
Hi I am now trying to create a excel macro to auto populate all the dates with reference to a start date and end date. The catch is that only working days are required in the range. My reference cells (start and end date) are in Sheet 1 while the destination cell range are in Sheet 2. The reason...
Hi all. I am trying to automate a Prepayment file. Basically I have the following data given in a row (entered via UserForm: -Amount of Invoice (+currency etc but not relevant in this context), start date, end date. In the columns there are months starting in July 2013 to June 2014. As I am...
I have a set of data which has dates in D4:AE4 starting from Jan 2011 to April 2013 underneath that i have data set of hours charged to a particular project. I am trying to see if there is a formula that i can use to determine the duration of the project based on what is populated in the rows...
Trying to query a call list to pull people who haven't been contacted since a certain date. So if my date is 10/10/2012, I want all people who's last contact was 10/10, 10/1, et al. I do not want to see people who were called by 10/10 but have been contacted since. Likewise, if multiple calls...
Hi guys,
Looking for some help. I am looking to use the manually entered 'Start' and 'End Date' to merge cells over this period, add 'Description', then colour code based on category.
How can i make this possible, usually quite competent, however, this has got me baffled!
I have a...
Wondering if this has ever been 'invented'....
I have a list of tasks, that contains a taskID, start date, end date, person to perform the task and number of hours that it should take to perform the task:
TASK WHO STARTDATE ENDDATE HOURS
0001 John 10/10/2008 10/15/2008 32...
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.