Excel formula for tds delay month calculation

Save Share

This query is : Resolved

MANESH WAGHMARE (Querist)
Follow

11 August 2013 Dear Sir,

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

Ganeshbabu K

Ganeshbabu K (Expert)
Follow

14 August 2013 1)TDS deduction date in cell "C1"

2)DUE DATE in Cell "C2"

3)Paid date in Cell "C3"

4)Delay can be caluculated "C3-C1" which will be in cell "C4"

5)Give IF Formulae as below

=IF[C4>30,2,1]

It will give results as you desired

MANESH WAGHMARE

MANESH WAGHMARE (Querist)
Follow

14 August 2013 Dear Sir,

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.

Ganeshbabu K

Ganeshbabu K (Expert)
Follow

14 August 2013 1)In C6 formulae =C2-C3

2)In C7 Formulae =IF(C5>0,C4,0)

I guess error resolved now!!!

MANESH WAGHMARE

MANESH WAGHMARE (Querist)
Follow

16 August 2013 Dear Sir,

Let me know the value of Cell "C5" which you are comparing with if formula.

Ganeshbabu K

Ganeshbabu K (Expert)
Follow

16 August 2013 Value arrived in point no. 5 in my first reply

MANESH WAGHMARE

MANESH WAGHMARE (Querist)
Follow

16 August 2013 Not getting.

Ganeshbabu K

Ganeshbabu K (Expert)
Follow

16 August 2013 =IF[C4>30,2,1]

MANESH WAGHMARE

MANESH WAGHMARE (Querist)
Follow

16 August 2013 The same problem is here.

CA Kumar Mukesh

CA Kumar Mukesh (Expert)
Follow

19 August 2013 The below formula will short out your query

For Due Date formula will be =
EDATE(A2,1)-DAY(A2)+7
Note : A2 is date of deduction

For no of month Defaults Formula will be =--(IF(B2
Note B2 is due date calculated above & C2 is actual date of deposit

MANESH WAGHMARE

MANESH WAGHMARE (Querist)
Follow

21 August 2013 Dear Sir,

Kindly write the whole if formula for no of moth defaults.

@VaibhavJ

@VaibhavJ (Expert)
Follow

22 August 2013 Hey

There are many conditions to be checked for calculating interest.

Pl check https://www.taxpointindia.com/calculators/tds/tdscalc.asp

Thanks

@VaibhavJ

@VaibhavJ (Expert)
Follow

22 August 2013 You can download excel file from here, earlier published on cci:

https://www.caclubindia.com/forum/files_download.asp?msg_id=1169097

Thanks

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now