end date

  1. A

    Networkdays by quarter and holidays

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

    Payment Period: To give End Date (mm/dd/yy) given the Start Date and Months

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

    Calculate end of stock date with NPER formular

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

    Calculation Ending DATE-Time knowing the duration time but following a specific hourly shedule

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

    Excel: Forecasting and Prorating Revenue By Month (Based on Start and End Dates)

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

    Macro to Autofill Dates between Start Date and End Date

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

    Formula NEEDED

    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!!
  8. R

    End date for recurring events which happens few times a week.

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

    How to auto populate date range (working days only) from start date and end date

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

    Spread Prepayments over specified period (Start & End Date)

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

    Finding Row Header or 1st and last cell populated with Data

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

    Distinct IDs by last contact date?

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

    'Start' and 'End Date' to merge cells over this period, add 'Description', then colour code based on category.

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

    Macro to add as many rows as difference between start date and end date

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

Watch MrExcel Video

This Week's Hot Topics

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
Top