I have calculated the total number of workdays between two dates by quarter using the formula below:
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...
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...
I'm trying to calculate the End Date Time knowing the Duration (in hours:minutes decimal unit) and following a specific schedule.
Monday: Start work at 7:30 until 9:00
Monday: Start work at 9:15 until 12:00
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:
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...
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!!
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...
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...