Question: how to calculate qtd in excel?
Answer: The formula should sum the current quarter to date based on the current month from cell D4. Therefore, the formula must only add up the number of cells in the current QTR in order to get a QTD answer.