Excel Forum

Pls... Need help on below excel formula~

Example I went to travel 19 days and travel allowance base on this:

1-5 days - claim 40 per day
6-10 days - claim 50 per day
11-15 days- claim 60 per day
16-20 days - claim 70 per day

Answer is 40x5 days + 50x5days + 60x5days + 70x4days

1030 in total ...

Hi Dear
I can't upload my file

Hey there i have such data set
A B C D
ITEM PRICE RANGE YEAR DISCOUNT
Fan 20 30 1 5%
Air con 350 495 1 …………… 5 %
TV 500 750 1 … 5%
Fan 20 30 2 4%
Air con 350 495 2 4%
TV 500 750 2 4%
Fan 20 30 3 3%
Air con 350 495 3 3%
TV 500 750 3 3%
i want to look up FAN with Price 25 nd year 1 to find discount ...

hi dear,
I have date 31/01/2016 i want to find Friday for this date?how can I?

I have solution by using VBA frm https://support.microsoft.com/en-us/kb/245104

If i want years ,months and days between these two dates?

i.e 15/10/1888 to 22/06/2016

Please provide formula

After that can we use datedif to do calculation?

I try use sumproduct and sumifs but it is not working fine,please give me another solution,i message u by messenger the screenshot

Dear
I have column A,B,C respectively
06-06-2016 16-06-2016 2137.50
16-06-2016 26-06-2016 2565
26-06-2016 06-07-2016 3420
06-07-2016 16-07-2016 997.50
07-07-2016 17-07-2016 897.75

I wanna calculate
checkin checkout
07-06-2016 17-06-2016 ?
17-06-2016 27-06-2016 ?
27-06-2016 07-07-2016 ?

please ...