dates between events

Hello! I am a beginner/intermediate user of Excel. I am in HR and track all stages of the pre-employment process. I need to show quantitative data - for example - the number of days it took from the time we extended an offer to the time we were able to onboard that person. Final Candidate...

Hi, Firstly, I’m an absolute novice on excel. However, I’m trying to get excel to return an accurate duration in years and months, based on a start date and end date. I found the formula below online: =DATEDIF(A2,B2,"y")&" Years, "&DATEDIF(A2,B2,"ym")&" Months" the issue with this formula is...

Good Afternoon, I'm trying to find a formula that will count the number of working days per month between two dates. I can do the number of working days per month between two dates (If "End Date is blank it calculates using the last day of the current month): Formula in C2...

Hello I have a spreadsheet COL A - contains a year COL B - persons name COL C - formula counting the number of years for the person named in COL B What I would like is to enter in COL D - the earliest year for the person COL E - the latest year for the person There can be upto 18 rows for...

Hello! Apologies if I don't word this correctly, I have a spreadsheet, In column AB (Actual Finish) is either a data and time that a job was finished, or blanks. In Column C, Is the start Date. Column H is the Priority, limited to either P1, P2, P3 or P4 I have built a table with months...

Hi all, I have a number of rent dates and need to round them up to the next quarter. However, I would like to be able to alter the start date so that the dates are rounded to the nearest 3 month period (not necessarily the same as the proper Quarter dates) e.g if the Start date is 31/01/2015...

Hi, I get an overflow error when trying to use dates in the extreme past or future. Is there anyway to add a .dll or hopefully something simpler to be able to make date calculations 500000 years from now or 500000 years in the past?:confused: Thanks for your help! K

Hi Team, I am new here and I need your help to solve a tiny problem that I am having. I am looking for a way to calculate dates inside days, so dates I have are below and days can be any number (lets call it 34 as an example). 20/01/14 07/03/14 26/03/14 18/04/14 24/05/14 21/06/14 So the 2nd...

Thanks to Barry Houdini I was able to calculate the average days between events in a table. I have a sales table with fields for salesperson ID, Sales Date, Sale Amount. Each person can have one or many sales in the table. I am trying to calculate the median days between sales for each sales...