Easy Office
LCI Learning

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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query