How to calculate days between two dates in excel

1448 views 2 replies

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: 267 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
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 18 June 2026
Article Assistance

RB KESHRI & CO.

Mumbai

CA Inter

View Details
Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details