datedif

I am compiling a database featuring many different people. I need to be able to list their dates of birth, dates of death, and ages. So far, I have split these into three columns, E, F and G respectively, but I am having some trouble with the "Age" column. I need this column to do two things, if...

Hi, I have a spreadsheet where I need to return a value for files with a due date within the next 7 days as Yes, Past due as "" and dates greater than 7 days return a "Future date"). current formula : =IFERROR((DATEDIF(TODAY(),M2,"D")<=7),""), brings back Blanks for past due, True for <+7...

Hi, I am using Microsoft 2010 and I am trying to create a tracker so that I can see when my training certificates are "in date", "out of date" or "due for renewal". I have a cell C1 with today's date. I have the dates of expiry of certificates in B5:B7. I would like to generate a formula...

I have a spreadsheet with the following cells. Cell B23= Purchase Date Cell $E$7 = Today's date Cell F23 = Purchase Price Cell F24 formula needed as described below I need to write a formula that compares the two dates and does the following. If the Purchase date B23 is after Today's date...

Hello I am stuck. I am trying to make a formula to calculate a premature baby's corrected gestational age using todays date (L1), Baby's Birthdate (D27) and Gestational age at birth (F27). Baby's gestational age is in the WW.D format. I THINK I am placing F27 in the wrong place because some of...

Guys please i have a little issue The difference in months from 'January to December' is 12 months. I tried calculating the difference between this months using the DATEDIF function but I keep getting 11months instead. Please how do i go about this. Thanks and regards

Hello, I have a table where a have dates in two columns running down about 400 dates each but they have to skip one cell so assuming I have A and B, the dates are in A1, A3, A5... and B1, B3, B5... What I would like to do is to get an average of the difference. For two rows it would be...

Hi there! I'm a newbie on the forum and quite exctied to be part of the community. I'm having some trouble with a nested IF function in my spreadsheet. There are a few different parameters I'm attempting to incorporate, and there seems to be a problem somewhere. I'm no expert, so any help to...

Hello, I am using a formula that calculates the length of time in Years, Months and Days. The formula is built up in a way that the result comes in as an alphanumeric value such as "2 Years 9 Months 3 Days". This formula is applied to a column of about 5000 lines. What I would like to...

the datedif formula is having a problem. =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days "&TEXT(MOD(B1-A1,1),"h "" hours "" m"" minutes "" s ""seconds""") Format: Date/time format (mm/dd/yyyy hh:ss) Consider A1= 10/6/2013 18:00 B1= 10/6/2013 18:00...

Hello all, I'm having some issues subtracting one set of DateDif formulas's from another. The formula below works fine in adding a number of date ranges together to output the correct answe in X Years X Months and X days, however I need to subtract a diffrent range of dates and time and the...

Hi all, I'm currently using the DATEDIF formula below to work out the diffrence between two dates contained in B242 and C242. =DATEDIF(B242,C242,"y")&" years "&DATEDIF(B242,C242,"ym")&" months "&DATEDIF(B242,C242,"md")&" days". The output displays as X years X months X days which is fantastic...

Hi Having a spot of bother with DATEDIF. I'm trying to count the number of full months between two given dates. DATEDIF was doing just fine until I got to February. I'm using =DATEDIF(Start Date,End Date,"m") and getting the following ... <TBODY> Start Date End Date DATEDIF result...

I know that since Excel 2002 this function doesn't appear in functions list and there's no help about it. But what is strange is that DATEDIF appears in official ECMA-376 specification - in first, second, and third editions. The description of this function can be found: 1-st Edition - Part 4...

Hi everyone! I’m working with a process chain that includes several dates. <o:p></o:p> <o:p></o:p> Explanation of Cells:<o:p></o:p> A1: Date for Initial Review (Should not take more than four days to escalate)<o:p></o:p> B1: Contains formula to determine whether timeframe of A1 is “OVER” or...

I’m using Excel 2007 and must calculate the number of months between two dates and the number of months in each year of that time for about 1000 rows. Formula =DATEDIF(A2,B2,"m") provides an answer of 27 months, but isn’t it 28? Counting 12 months from July-June and then 4 more from...

Hi All, Trying to calculate age in years in VBA. I'm using this: Label10.Caption = DATEDIF(TextBox72.Value, Date, "y") Where textbox72.value is a date that the user enters. The problem: I get a "Sub or function not defined" error. What am I doing wrong?

I need a datedif formula to look at the months and days between two dates and display only the months. However, i need the result (number of months) to be rounded up if the days are 15 or more and rounded down if 14 or less. right now i'm using this formula, but i'm not sure how or where to...

I have a worksheet which calculates the amount of time an employee has been with our company. I currently use datedif, but i am unable to sort properly using this method. Is their a way to change the output using datedif from m,d,yyyy to mm,dd,yyyy? If not, anyone have a vba solution? Thanks...

I have rental amount in column H, contract date in column K and program end date in column M. I want to calculate the amount of total rent. If contract starts before March 2008, then the formula should calculate the months (like 4.3 month etc) and multiply that to the rent amount column H, and...