datedif function

As you see guys! What's the problem? I do it perfectly. also the version of excel is 2010.

Hello, I am struggling with my IF function as it is copying down but the formula turns grey and does not adjust for the row it is moving down. Essentially, I am looking to calculate the time to fill which was originally done by using the DatedIf function containing job posing date and the...

Dit is geen vraag, maar een oplossing voor wie er naar zoekt: een UDF die verbeterd de functie datumverschil uitvoert: wie de periode tussen twee datums wil omschrijven met jaren, maanden en dagen, zonder dat er 0 jaar of 0 maanden of 0 dagen tussen zit, kan deze formule gebruiken ... Perfect...

Hello! I am trying to use a DATEDIF formula to calculate a number that is then used to in an IF formula to generate a score. The issues is that for some of the DATEDIF calculations the EndDate is before the StartDate. When this happens, I have the formula generate a "0". I then use the...

--- Problem 2 - Mr Excel Forum Change this formulae needed so it works in Excel 2010 version who have no datediff formula available ? Getting hundreds of client sites to upgrade in 24 hrs not possible. =IF(ISBLANK(U15), "", DATEDIF(U15,$V$3,"y") & " y, " & DATEDIF(U15,$V$3,"ym") & " m ")...

I am sure this has been asked before, but I need all the assistance I can get with this...We have implemented a new tracking system that requires us to calculate the total numbers of days between two dates if one cell contains a date. However, one of the dates you must add one day to it then...

I have to run certain processes and repeat them every 6, 12 or 24 months. I have details of the process in an Excel 2007 workbook. In the spreadsheet I have the start date that the process needs to run in column W and how regularly it needs to be repeated (every 6, 12 or 24 months) in column X...

I have tried to do this for the last hour or so and it's kicking my butt. I'm in Excel 2010, and the cell with the date I want to work from is H22, can anyone help me please? I'm trying to get the difference of the (date+12 months)-TODAY() to appear in months and days. Here's the latest...