dateif

Hello, I really really need some help for this situation. I can not seem to find the way out here. I have these start dates and and end dates . how can i use a formula like this, throughout all year long ? Formula for now is : =EDATE((DATE(YEAR($A$37);MONTH($A$37)+(I42);DAY($A$37)));1)-1 ...

Hello everybody, can you help me? If I delete the value of txtPrazoPagamento or the value of txtDateVencimento. I get this message: Run-time '13' Type mismatch Private Sub txtDataVencimento_Change() If CDate(txtDataHoje) > CDate(txtDataVencimento) Then txtAtraso.Value = Abs(DateDiff("d"...

Hello forum friends, I have an issue with the results of a DATEIF formula I am trying to build. I am receiving a result of $161.92 and it should be $50.06, so I am WAY off somewhere. I have included snapshots of the cells in question below. If anyone has any ideas, I will be grateful. Excel...

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

Hi, I am having trouble working the logic for the below scenario:- I am aiming to achieve a workbook that will automatically tell me what deduction to make if time between two dates is under 2 years (100%), 2-3 years (75%), 3-4 years (50%) and over 4 years (0%). I have a workbook with a list...

Hello, I need help with how to use the dateif function to get the date difference between two dates that's today's date and a date inside a textbox say TextBox1 in vba. I want it shown in years, months and days. Example : 1 year, 10 months and 11 days Thanks in advance Kelly

Hi I am looking help for a formula concerning values and dates in a range. Table 1 consist of aggregate audit values at specific dates. These audit values represent the sum of values between the dates. Table 1 <tbody> Audit values 3.1.2017 5.1.2017 9.1.2017 Value 12 10 24 </tbody>...

Hello, I'm an analyst for and airport. I would like to count number of days between the landings of different aircraft types (cargo aircraft or freighters). The data does not come in clean. My first column is dates. The following columns are aircraft types, but each day the same aircraft don't...

Could you please provide a formula that will calculate the end of the birth year in which a child reaches age 29? Trying to project the end of insurance coverage for dependents that reach maximum age. Coverage terminates at the end of the calendar year in which they reach age 29. Many thanks!!!

Hello, I am new to this Mr. Excel website. I have a question in regards to a formula I am trying to make. I will give you a description of the spread sheet and explane what I want to achieve. I have a spread sheet with many columns A-AA. Column (L) is <start date> (M) is finish date (Q) is...

hi mr excel i have question <tbody> A B C D E F G 1 2 2013-12-20 18 2014-01-10 0 8 2 4 2014-01-04 0 2014-02-10 0 6 3 5 2014-02-01 -4 2014-03-01 0 -25 4 1 2014-01-29 28 2014-03-10 1 9 </tbody> Red words is the result that my expected where D1 = C1-B1 (date) F1 = E1-C1...

My Formula is currently =SUMIF($F6:$F9,D77,$C6:$C9) with the column C being different purchase costs, F being the respective purchase dates, and D77 contains the month of the cash-flow for the date to flow to below. At the moment the dates need to be on the first day of the month to flow to the...

I need a formula to sum financial transactions according to the month; however it is a running total and the number of transactions in each month are initially unknown. In column A, I have dates (Jan 1st, 2nd, 3rd, etc.) and column B the corresponding financial transactions associated with...

Hi, I need help. If date falls between 1st saturday of nov and 2nd saturday of december then B1 = x else y Thanks for helping. Pedie