How we can calculate the days between two dates
This query is : Resolved
24 April 2009
Can any one have the idea how to calculate the difference between two days in excel.
Eg. suppose i want to know the difference in days between 1.4.2008 to 31.12.2008. Then how can i calculate in excel.
Plz do reply me.
Ramsankar
Eg. suppose i want to know the difference in days between 1.4.2008 to 31.12.2008. Then how can i calculate in excel.
Plz do reply me.
Ramsankar
24 April 2009
Enter both dates, viz., 12/31/2008 and 4/1/2008 in date format. Subtract date 4/1/2008 from 12/31/2008. Formt the cell in which you require answer in number format (zero decimal points).
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
- CG Tax On residential property
- Applicable TDS for Purchase of Flat from NRI
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- Under construction property in ITR
- Gift of mutual fund units to daughter
- Not able to file ITR
- Upload Level ValidationITR3Category of Defect B/D
- Building tax payment deduction in rental Income
- Reporting of STCG on Property in ITR
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
