Kindly share the Excel formula for TDS Delay months Calculation.
Eg : if TDS Deduction Date is 04/05 /2013 and its due date is 07/06/2013. But Deducted deposited TDS amount on 09/06/13 the it should be display 02 delay months.
Note : For each month due date is 07th of Next month except March is 30th Apr
In the above formula you have not considered the Cell "C3". Pls refer the below equation Tds deduction date is 04-04-13 and due date 07-05-13. If we apply the said formula then it return the value 2 months delay. But actually there is no delay months.
CAclubindia
