How to calculate days between two dates in excel

1500 views
User Avatar

none
29 Points Posted on 01 December 2011

If you of anyone help me i would be greateful 

i got confuced to calculate days in excel between  two difference dates . i have attatchted file please put formula in days column.

          and please tell me how to calculate ?

Attached File : 640471 877857 calc days.xlsx downloaded: 285 times
Reply Share Follow Topic
On 01 December 2011 at 13:01 Report
Replies (2)
User Avatar

Job
188 Points Posted on 01 December 2011

Dear 

its simple substraction formula.

 

Find the attached file.

1 Reply
On 01 December 2011 at 13:17
User Avatar

STUDENT
248 Points Posted on 10 December 2011

use =DATEDIF(A1,A2,"D")

Reply
On 10 December 2011 at 08:32

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topics :

  1. Scanned purchase bills to Tally XML with GST check
  2. TDS applicability of foreign remittance to Oracle
  3. GSTR 9 LATE FEE
  4. Best Online Mock Test Series for CA Inter January
  5. COST OF IMPROVEMENT
  6. Pillows and Mattresses
  7. GST Applicability for Reg. / Un-Reg. Indian custom
  8. Amended GST Act & Rules
  9. FAST DS 2026 MAIL QUERY
  10. Does Anyone need CA Foundation books of May2026 at

More recent discussions | Post

Related Topics :

Loading

Latest Job Openings

View all
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details