Actually i want to count that how many dates are available in the data which are 65 years older than the date which are provided as “Effective Date” .
please help me anyone.
Greetings !
Exact amount not receiving when i changing the compound interval from "yearly" to "monthly".
Detail is shown below:-
Total days-422
Rate-21%
Formula result-127182
Result needed-127215
Greetings !
interest to be calculated for everyday but compound interval is "yearly" therefore i have calculated in excel but result is not correct.
Compound formula Result in excel sheet is 22911 but result shall be 23088.
Required result -23088
Please find the attached excel sheet and...
Greetings to All !
i am using the following formula but it is not providing the correct answer.
INDEX($J$17:$J$20,MATCH(1,INDEX(($H$17:$H$20=A7)*(OR(($I$17:$I$20=B7),($I$17:$I$20=B7+1))),),0))
Formula is not working at highlighted area and giving incorrect answer therefore please find the...
Recharge Validty to be fetched from DATa Base for a person if Transaction time is between the validtity.
Please find the attached sheet for necessary support .
Thanks in advance for the nice support.
i have name in column A and vehicle no in column B then i am getting total trips of each individual through pivot table but i need following also in front of pivot table:-
i would like to know that how many vehicles are listed on individual name . please find the attached and help me
Sir If previous transaction status found rejected then Latest transaction to be checked from 2nd last transaction instead of previous transaction.
My formula is working correct if all transaction status is accepted
Dear Friends
Greetings !
As I shall enter the duplicate entry for a name then all his previous results should reflect in another column.
Detail sheet is attached for reference.