How can calculate DA in salary in Excel?
John Hall
Updated on February 16, 2026
The formulae for calculating dearness allowance are as under: For central government employees: DA% = ((Average of AICPI (Base Year 2001=100) for the past 12 months -115.76)/115.76)100 For central public sector employees: DA% = ((Average of AICPI (Base Year 2001=100) for the past 3 months -126.33)/126.33)100 Here.
What is the full form DA?
DA or dearness allowance is calculated as a specific percentage of the basic salary which is then added to the basic salary along with other components like HRA (House Rent Allowance) to make up the total salary of an employee of the government sector.
What is DA in salary?
Dearness Allowance
What is Dearness Allowance. Dearness Allowance is paid by the government to its employees as well as a pensioner to offset the impact of inflation. The effective salary of government employees requires constant enhancement to help them cope up with the increasing prices.
What is DA in Excel?
Dearness Allowance Calculations DA (Dearness Allowance) = 2% to 4% of Basic Salary. You can find these terms in your salary slips. You can download ready to use Salary Slip Excel Template from the link below.
What is the formula to calculate basic salary?
What Is Basic Salary? Definition, Formula & Income Tax
- Annual Basic = Monthly Basic X 12.
- Gross Pay = Basic + DA + HRA + Conveyance + Medical + Other.
- Basic = Gross Pay – DA – HRA – Conveyance – Medical – Other.
- Basic = Gross Pay X Percentage.
What is Ma in salary slip?
Gross salary = Basic salary + HRA (House rent allowance) + DA (dearness allowance) + MA (medical allowance).
What is the current DA rate?
Dearness Allowance (DA) increased from 17% to 28%: 10 things to know. The Centre on Wednesday increased the Dearness Allowance (DA) and Dearness Relief (DR) for central government employees and pensioners by 11% from the existing rate to bring it to 28% effective from 1 July, 2021.
What is basic salary example?
For instance, if an employee has a gross salary of Rs. 40,000 and a basic salary is Rs. 18,000, he or she will get Rs. 18,000 as fixed salary in addition to other allowances such as House rent allowance, conveyance, communication, dearness allowance, city allowance or any other special allowance.
What is Da in WhatsApp?
“District Attorney” is the most common definition for DA on Snapchat, WhatsApp, Facebook, Twitter, Instagram, and TikTok. DA.
What is a Da mean?
district attorney
A DA is a district attorney.
What is the DA from Jan 2020?
The central government employees are going to get the benefit of two years’ DA directly as the dearness allowance of the central government employees had increased by 4% in January 2020, then there was an increase of 3% in the second half i.e. in June 2020.
What happens when DA crosses 25%?
The Department of Expenditure had issued an order on 7 July 2017 stating that when the dearness allowance crosses 25 percent, the house rent allowance will be revised. Since July 1, the dearness allowance has been hiked to 28 percent, due to which the house rent allowance has also been revised.
