Search results

Dear Mohammed, If I change joining date to 25th April then the amount should be calculated by 6 days also, thanks for your support.

thanks for sharing policy, but i want same previously discussed calculation.

if i change joining date no of days not calculating please check attached

consider April, I have to calculate calendar days. such as 31 or 30

no, joining date will not be 1st and end date will not be last date will be any date

in case if I change end date 30/09/2023 amount will change 18 months 583.00 * 18 10,494.00

from Apr 2022 to Aug 2023 17 months am i right? % monthly as per my sample file 10000*5.83%=583 one month = 583 thanks your support

Each month 8.33% 583.00 Total 17 months 9,911.00 this is the correct amount

as per your result only one month calculation, i am expecting each month same as 5.83% more than 5 years 8.33%, please check as attached

D Dear i know how to verify, but formula issue only, if you know just do it i will verify

I don’t have idea

Yes

End of service Benefits, what is the benefits amount to be first 5 years and after 5 years including total amount.

Dears please help me for calculating EOSB calculation as per attached excel list

Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Total 80.26 80.26 77.67 80.26 (2,570.92) (2,252.47) total should be 318.45

attached sample file (promoted column 1 has promoted staff, 0 mean not promoted)

please answer as attached

t thank you very much

what is the formula

A B C D E 1 Jan-19 Feb-19 Mar-19 Apr-19 Print Negative amount only 2 306.85 339.72 328.77 (19,517.81) 3 (3,637.60) 4 (11,813.22) 5 (17,368.15) 6 126.58 140.14 (14,644.32) 7 165.93 183.71 (12,358.73) 8 169.92 188.12 (20,842.24) 9 421.54 466.69...

Great MOD is working well

B column is next day

but this is not correct