1. T

    DATEDIF formula with multiple criteria (IF ...)

    Hi everyone, So in Excel 2010, I have a DATEDIF formula that works perfectly, which is: =IF((AND(Y:Y<>"",B:B<>"")),DATEDIF([@[Date of inclusion]],[@[Date of discharge]],"d")/7,""),IF((AND(B:B<>"",Y:Y="")) B shows the first date (date of inclusion) Y shows the second date (date of discharge)...
  2. V

    Combining ISBLANK and NOT(ISBLANK() to calculate dates..(or other suggestions)

    Hello, For a document at work I need to calculate the total days that we have had someone stay at our property. Something that should look like below. Room Room (per person) Date in Planned Date Out Actual Date Out Total Nights 1511 1511 25/09/2020 9/10/2020 7 1511 25/09/2020...
  3. S

    Count number of cells under a certain period of time in y m d format

    Hello, I'm looking to count the number of times a value is under a certain period of time (in this case, two years). The tricky part for me is that I'm trying to count cells populated with a "#y #m #d" format from a DATEDIF formula. Example below: DATEDIF formula used in B2 and copied down...
  4. L

    datedif() arguments

    Hi I want to understand datedif() function. What I do not understand the logic behind "Y", "YM", MD" Why YM to find month, why not only M? and why MD to find day? why not D same as Y for year. I do not understand the logic behind YM and MD? Thank you so much = datediff(A1,today(),"Y") - to...
  5. L

    Calculate Age

    Hi I am trying to find the best and easiest way to calculate age. I thought it is something easy but it turn it is a bit complex. The websites below showing how to calculate age. But I only found is better and easier yet it is not that easy because they use a function called...
  6. O

    Trouble Using Formulas in VBA

    Hi, I have a specific problem with some code, and then a general question to ask as well. I started learning/writing VBA code about 4 months ago; therefore, I apologize for my ignorance on a lot of this stuff; anyways, my general question would be, 1. Is there any general / simple way to use...
  7. I

    DATEDIF when two dates are the same

    Hi I have this formula which i am using to find the number of days difference between from two dates DATEDIF(F5,P5,"D") when the two dates are the same it is coming back with 0, how do i change this formula so when the dates are the same it brings back 1? Thank you
  8. V

    where do i get Dateif formula

    Hi team, where do i get Datedif formula, in which version of excel?
  9. L

    IF ELSE Usage

    Hello I started a new job and I need help with my excel sheet. I have a column with dates. At the bottom I am using =MAX(F1660:F1680) to result the most recent date. Then I am using =DATEDIF(F1681,TODAY(),"D") to use the result of MAX date to count the number of days since the most recent date...
  10. C

    DATEDIF not working.

    Hi, Trying to retrieve the number of months between the two dates below. Dates are generated through functions beneath. 2019-01-01 A1=DATEVALUE(YEAR(TODAY())&"-01") 2019-04-01 B1=EDATE(DATEVALUE(MID($C$12;18;4)&"-"&MID($C$12;23;2));1) =DATEDIF(A1;B1;"M") does not work, returns "1900-01-03"...
  11. Z

    Odd DATEDIF Result

    <p>I was wondering if any of you have seen this sort of result from DATEDIF. I am using this function to determine the age in years, months, and days of various items. </p> <table> <tr><td> </td><td>A</td><td>B</td><td>C</td></tr> <tr><td>1</td><td>Start Date</td><td>31-Jul-17</td><td></td></tr>...
  12. M

    Monthly report for yard activity - ISO best method

    Hi, I'm new to the forum but I've been using Excel for several years. I consider myself at least an intermediate user, however I don't write a lot of code. Better at copy paste, edit. I inherited the task of adding some KPI's to an already existing workbook. It was full of missing and...
  13. 0

    Generating a DATEDIF value of "0" when the EndDate is in the past and then using in IF formula

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


    Hi Why datedif() is hidden function? are they other functions hidden? Thank you very much.
  15. M

    DateDiff Mystery XL2007

    Hi, I am quality checking some work that took a few weeks to complete. I used the DateDif function to calculate the number of whole months between two dates. Here is an example: =DATEDIF("9/18/2014","2/17/2015","m") Result = 4 I know that this function will round down to the nearest whole...
  16. M

    Problems using DATEDIF() function

    In my sheet I import dates in the format dd-mmm-yyyy which is the english region format. My problem is that my Windows is set up to Danish region format (dd-mmm-åååå). This causes the DATEDIF() function to fail. The DATEDIF() function works if I go to the Windows region settings and change to...
  17. S

    Matching day due with bill amount and falling under the appropriate date range. Quite challenging.

    Hello. I'm trying to create a chart that automatically updates cells based on multiple criteria. I have been working on it for a week and I'm getting close. I can get some data to cooperate, but I have a few obstacles. I have made a second chart below the main chart that uses the old...
  18. C

    Datedif: Error: You've entered too many arguments for this Fuction

    please help i have this formula and it is giving me a Error: You've entered too many arguments for this Fuction =IFERROR(IF(DATEDIF($V15,$W15,"y")=0,"",DATEDIF($V15,$W15,"y")&"y ")&IF(DATEDIF($V15,$W15,"ym")=0,"",DATEDIF($V15,$W15,"ym")&" m...
  19. E

    Date Formulas with IF ?

    Hello, I was wondering if someone can help me in creating a formula based on dates. I need the formula to be able to tell me the month of a set date depending on the day of the month. The criteria is: If the start is after 1st of the month, populate the following month, if not use the...
  20. N

    Sumproduct and datedif #num error

    Hi, I'm working on an excel function after many years away and I have come a little unstuck. I understand the problem I am just struggling to find a solution to it and would appreciate any help anyone might be able to offer. The function is straightforward <code>...

Watch MrExcel Video

This Week's Hot Topics

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
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