datedif formula

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

Hi there, I want to create a worksheet that tells me how much time has past or is there until action is needed. So there is an appointment which needs to be taken every 2 years. I want to see how much time in months is left until they need to take it again or how many months day are overdue...

I have a formula to show when a given date was in the past and how long ago it was but I need it to display when a date is in the future as well rather than returning #NUM, if possible just saying "Future" would be fine. The formula I'm using is...

Hi, I'm trying to group dates under tenure grouping and some group members here helped with suggesting the formula I'm using in my below example, but I noticed the tenure category grouping has some issues as it's not choosing the right group when the months of service is greater than 5 years...

I am trying to create a formula that answers the following question: What is the Tenure at the end of 2018 (12/31/2018) for a person that has a HIRED DATE before 12/31/2018 and has a TERMINATION DATE that is either within or after 2018. I really appreciate the help, I just cant get the...

I have a spread sheet with two dates, I am using the following formula which works great if both cells are populated, but if one is not populated with a date I get #NUM!. If one of the cells is not populated I want the cell to be blank. =DATEDIF(D3,E3,"y") & " Years, " & DATEDIF(D3,E3,"ym") & "...

I need to create a mark book. =VLOOKUP(G3,'Yr5 Maths Aut'!$A$1:$U$112,MATCH(I3,'Yr5 Maths Aut'!$A$1:$U$1,0),0) The Vlookup table uses the following Ages 9 yrs 1 month, 9 yrs 2 months etc to 9 yrs 10 months. Total 9.00 9.10 9.20 ….. 9.90 9.10 9.11 10.00 10.1 The problem is...

Good morning! I need help with a DATEDIF formula. This is my original formula: =ROUND(IF(YEAR(AC93)=2018 & MONTH(AC93)=8,"0",DATEDIF(AC93,"8/1/2018","m")/12),0) It works perfectly when the date in cell AC93 is 8/1/2018, which is what most of the 1,000+ employees I'm calculating years of...

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

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

Need help calculating the number of days between dates for particular statuses. Each record has multiple statuses (status field is Column B) and dates associated with that status (date field is Column C). a simple datedif() would be able to compare dates in different columns or different rows...