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

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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 20 November 2026
Article clerk

Jain Sanjay Kumar & Co

Jaipur

CA Inter

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details