how to calculate ytd percentage in excel?
To calculate YTD, subtract its value on January 1st from its current value. Divide the difference by the value on January 1st. Multiply the result by 100 to convert the figure to a percentage.