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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Tds on building rent monthly
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Confusion around Form 26QB fields
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Clarification on Documentation of Paid-Up Capital Contribution by Directors
- TDS under section and rate of TDS
- GST input on scooter purchased
- TDS under section 194Q and TCS under section 206C
- GST input on car insurance and repairs
- GST input on Diwali gift to employee
- GST input on Mobile Handset
- Material and freight in same invoice
- TDS under section 194J inclusive of reimbursement of expenses
- TDS on Material and Labour in same invoice
Trending Online Classes
CAclubindia
