end date

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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!!
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...

Some videos you may like

This Week's Hot Topics