Tds interest calculation formula

This query is : Resolved 

02 February 2012 DEAR FRNDS

PLS GIVE ME EXCEL FORMULA FOR COUNT MONTH REGARDING TDS INTEREST CALCULATION
EXAMPLE:-

BILL DATE IS-29/04/2011
TDS PMT DATE 25/01/2012
TDS AMT 50000

SIMPLE MONTH COUNT IS 10
BUT WHEN I CALCULATE WITH FORMULA MONTH IS CALCULATE 9.

PLEASE SHORT THIS AS EARLY

THANKING YOU

MUKESH

02 February 2012 29/4/2011 - 29/1/2012 = 9 months

on or after 29/1/2012 = 10 months

As payment date is 25/1/12 , 9 months is correct


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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
23 July 2026
Semi qualified CA

Garg Bros & Associate CA

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
2 posts Article assistant and Articleship completed students

Chirag N Shah & Associates

Mumbai

CA Inter

View Details
Company
22 July 2026
Senior Chartered Accountant

SKSS

Patna

CA

View Details
Company
23 July 2026
CA Inter

Vikram Jadhav and Company

Pune

CA Inter

View Details
Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
ARTICLESHIP 08 July 2026
Article internship

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details