start date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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