datedif

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

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

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

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

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

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

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

I'm using the following formula which works great until it needs to return a negative number: =DATEDIF(G13,D13,"D)) D = exp date G = date quote sent if date quote sent is after exp date, it doesn't return a number. Is there an easy way to resolve? Thanks! Jess

Hi, Is there anyone could help me. Is it possible to auto calculate datedif function because I have many data.ex: I have 10 date in column A & B. Column A (date start) Column B (date end) Column C( datedif total) Tq.

My formula is : =DATEDIF(O2,AL$1,"y")&" years, "&DATEDIF(O2,AL$1,"ym")&" months, "&O2-DATE(YEAR(O2),MONTH(O2),1)&" days" Where O2 is the hire date and AL$1 is today() The formula works, kinda. It isn't doing the math correctly. I have a person who started exactly a year ago and it is 2...

Hello I'm using DATEDIF function to calculate number of days difference between two dates. I have a spreadsheet with many rows of data and two columns, one for the start date and one for the end date. Some rows do not have an end date. In this case I want to calculate the difference between...

Is it possible to add a piece of text to say that there is no end date in the DateDif calculation I have this =IF(DATEDIF(J18,K18,"m"),"No End date") and I get the #VALUE returned

HI ALL. What's wrong with the following formula? the result is <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> #NUM! </tbody> DATEDIF(I2,T2,"y")

I have two date. I want to count number of days between. Dim date_today, test_date As Date Dim result as Long date_today = Format(Now(), "dd/mm/yyyy") test_date = Format(wsM.Range("M10").Value, "dd/mm/yyyy") result= DateDiff("D", date_today, test_date) But the result is wrong, it's 539...

Hi there I have the following formula IF(L4>I4,DATEDIF(I4,L4,"d"),-DATEDIF(L4,I4,"d")))) I column is the due date and L column is the completed date The formula is working to show completed task delivery (positive or negative) against due date However, I would like to exclude weekends from...

Hello, I am trying to track the remaining life span of a product (5 years), when the life span is only reduced when the item is in use, not when in storage. If the product has a 5 year life and Jane only used it for 10 months and 19 days, how much of the 5 years remains? Worth noting is I do...

Hi everyone, I am putting in a column to proof out that I have the correct balance for my prepaid item based on the number of months remaining based on the end date of the item and the current month end. I have my current month end date (7/31/17) in cell Z4, and the contract end date in cell...

Hi, I need to calculate the tenure of employees in my org, i wrote this code however I keep getting an #value error, can someone help me? =DATEDIF(C2,TODAY(),"y") & " years, " & DATEDIF(C2,TODAY(),"ym") & " months " C2 is the cell where I have the employees joining date.

Good Morning, I've been browsing the forum and I'm having difficulty trying to find an answer to what I am trying to do with my workbook. I'm sure it's a very simple answer, but I'm hoping someone may be able to help me please. I have an attendance chart that also calculates how long an...

Hi -- I hope this is is a simple ask what's the best way to calculate the difference b/w two dates (in # of months) with the result rounded to the nearest hals month. So the difference between 4/15/2017 and 6/30/2017 would be 1.5 (instead of 2) Thanks!