You'll have to be more specific. There are a number of different methods used to calculate a discount rate. Which method do you need to use? Also, once you know that, you can pretty much just enter the mathematical formula into Excel just as you would write it on paper to get the answer.