start date

  1. M

    count from a starting date but stop after 5 items fi,d

    Hello! This is my 1st time here! I have a tabel wher a person compile a P/N in Column A, and I whant to return in a Column AS an hiperlink (text to show & absolut adress + criterias in a separate tabel) Once confirmed a value entred in column A, a date Now(), with vba is autocompiled in column...
  2. A

    [NOT SUM] Assign Values based on Start Date

    Hi all, here is the context: I sell software subscriptions, each varying in start date and duration It is important to know the monthly totals for subscription sales (i.e. new sales + monthly reoccurring revenue from deals that already closed) I am trying to figure out a method / formula to...
  3. J

    Quarter Years based on Start Date

    Hello everyone... I have a situation that is really puzzling with me, so I thought I would ask on the forum. In column A, I have a list of "start dates" (ex: 1/1/2017, 5/1/2017, etc) In row 1, I have consecutive date headers (i.e. 1/1/2017, 2/1/2017, 3/1/2017, 4/1/2017 .... )...
  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. B

    Complex Formula Based on WBS Formula

    I'm trying to find a formula that will help me to auto-calculate the Start Date, Due Date, and % Complete based on an existing formula for Work Breakdown Structure (WBS) in a Gantt Chart. I have a project plan/gantt chart that has three levels of detail in the WBS (1, 1.1, 1.1.1, etc.). Here's...
  6. P

    Recurring dates, that end at a specified stop date

    Hi all I have the following XL sheet. The formula in Cell C3 is repeated all the way across Row 3, so that it always calculates the date (in Column A) plus the number of months noted in Row 2. I would like to know how to make the formula generate a blank cell, if there is an end date entered in...
  7. 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...
  8. N

    Starting a countif based off a date?

    I've been a bit of a lurker for some time. Getting my excel knowledge mainly from this forum! But, I need some help and can't seem to find the solution or something similar I can work with. Any help is much appreciated!! Current layout is: A1 = Dates | B1 through E1 = Quarter 1, 2, 3, 4 | F1...
  9. 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...
  10. B

    Start date from end date and text string help

    Hi all. TIA for viewing/helping If column A1 I need to find a start date B1 is an end date in the following format: 02/03/2014 C1 is a duration of employment typed in the following format: 11 yrs 6 months How can i get a start date (Column A) based on the column B and C data. Many thanks
  11. 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!!
  12. 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...
  13. 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...
  14. 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...
  15. L

    "Next Date" with known frequency and start date

    Help desperately needed. I don't think this should be too tough but for the life of me can't figure it out. I need a formula for Column C which will auto populate based on today's date Today(). Since we know the start date and the frequency, I just need to formula which gives me the next date...
  16. O

    Function behaves differently in two PCs

    I have a table with projects. The start date is in cell A5 and the due date in cell D5. I need to know if the dates were entered correctly, and if so how many days remain to the due date (or how many have passed since it). I have this function (which usually works well): [CODE]...
  17. C

    Calculating Start Date without using Workday()

    I am attempting to calculate the start date when the desired end date is known (Column D), and the duration to complete the work is also known (50 days, Column C). I'm using Excel 2003, and this info will be broadcast to multiple users, so using the Analysis Tool Pack is not an option. Is...
  18. 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...
  19. C

    Scheduling Data Collection

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am using a macro to collect data on manufacturing processes every 5 minutes, Our Company has 3 shifts. On week days I can start the macro when I leave to collect data through 2<SUP>nd</SUP> and...
  20. 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

Top