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: 271 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
23 July 2026
Semi qualified CA

Garg Bros & Associate CA

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
ARTICLESHIP 10 July 2026
Article Assistant

N S Gokhale & Co

Thane

CA Inter

View Details
Company
ARTICLESHIP 14 July 2026
Article Assistants

R Shyam and Associates

New Delhi

CA Final

View Details
Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
06 July 2026
Accountant

Agarwal Anoop and Associates

Noida

CA Final

View Details
Follow