Forum Discussion
Percentage calculation between two dates.
Hi everyone , Hope you are doing well. I need some help on one excel formula, I searched on internet but couldn't find it. Suppos I placed a purchase order to a company for some materials, an...
Kamransayed , it was not exactly clear whether you wanted deduction %age or the dates difference %age
Anyway, attached file could give you some hint
=+MAX(0,MIN(0.05,FLOOR((D5-C5),7)/7/100))
See example file attached.