The excel formula for percentage is Portion Days Total Days 100. To calculate averages in Excel start by clicking on an empty cell. Type the equation you want to calculate.
If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of.
For simple formulas simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use the plus sign to add the minus sign - to subtract the asterisk to multiply and the forward slash to divide. Where A2 is an earlier date and B2 is a later date. To use these examples in Excel drag to select the data in the table then right-click the selection and pick Copy. But well assume you want to add the sum to the workbook itself.