How we can calculate the days between two dates
This query is : Resolved
RAMSANKAR MISHRA
(Querist)
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
K V Subba Rao
(Expert)
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
- Depreciation Chart Companies Act
- EPF ECR NEW FILE SEP 17TH 2026
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Capital Gail Exemption Certificate
- Utilisation Fy 25-26 TDS challans in Fy 26-27 TDS Return
- Transfer of Physical Stock Between Two Proprietorship Concerns
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Under marginal scheme
- Clarification Requested: Gift → NRO → NRE → Overseas Transfer - USA/CANDA (FEMA & Tax Compliance)
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
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
