How to calculate days between two dates in excel

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: 276 times
Replies (2)

Dear 

its simple substraction formula.

 

Find the attached file.

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
17 August 2026
Chartered Accountant with US GAAP Experience

Austin Med Solutions Pvt Ltd

Bengaluru

CA

View Details
Company
04 September 2026
CA inter Or ca finalist

A Jaiswal and company

Lucknow

CA Final

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
18 August 2026
Audit Assistant - Remote / Work From Home

CA ANOOP P K & ASSOCIATES

Kozhikode

CA Inter

View Details
Company
ARTICLESHIP 17 August 2026
Article Assistant

K R Kiran Kumar & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 24 August 2026
Chartered Accountant Articles

Rohit KC Jain & Co

New Delhi

CA Inter

View Details
Company
21 August 2026
Finance Manager

Resollect Technologies Pvt Ltd

Mumbai

CA

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details