Use the DATEDIF function when you want to calculate the difference between two dates. 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. If youre in Excel you can go to File Open or you can right-click the file in your file browser.
First put a start date in a cell and an end date in another.
There are two ways to perform the calculation in Excel one is Formula and the second is Function. Type the equation you want to calculate. 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.