start date

1. Extract Dates from Table into new Table

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...
2. Formula or VBA?

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...
3. 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...
4. 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...
5. 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...
6. [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...
7. 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 .... )...
8. 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...
9. 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...
10. 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...
11. 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...
12. 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...
13. 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...
14. 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
15. 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!!
16. 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...
17. 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...
18. 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...
19. "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...
20. 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]...

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.

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

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