Excel formula for tds delay month calculation
This query is : Resolved
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
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
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
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
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.
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.
14 August 2013
1)In C6 formulae =C2-C3
2)In C7 Formulae =IF(C5>0,C4,0)
I guess error resolved now!!!
2)In C7 Formulae =IF(C5>0,C4,0)
I guess error resolved now!!!
16 August 2013
Dear Sir,
Let me know the value of Cell "C5" which you are comparing with if formula.
Let me know the value of Cell "C5" which you are comparing with if formula.
16 August 2013
Value arrived in point no. 5 in my first reply
16 August 2013
Not getting.
16 August 2013
=IF[C4>30,2,1]
16 August 2013
The same problem is here.
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
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
21 August 2013
Dear Sir,
Kindly write the whole if formula for no of moth defaults.
Kindly write the whole if formula for no of moth defaults.
22 August 2013
Hey
There are many conditions to be checked for calculating interest.
Pl check http://www.taxpointindia.com/calculators/tds/tdscalc.asp
Thanks
There are many conditions to be checked for calculating interest.
Pl check http://www.taxpointindia.com/calculators/tds/tdscalc.asp
Thanks
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
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- GST on export of services and Input Credit
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Should I report my US salary for January, February, March in Schedule FA?
- GST ON EXPORT COMMISSION
- Sale of property furniture sale
- BUYING PROPERTY COULD NOT FILE 26QB
- Gst input for FY 23-24
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
Trending Online Classes
CAclubindia
