How to calculate days between two dates

I would be greatefull if any of you expert will help me ,

I am very confuse after reading help on google but for calculate days between two dates, finally i m unsuccessfull please open my attatched file and please reply me what is formula to find out days within two dates, formula will required in red highlighted column please fill up formula 

                                                                                                                                     _______Thank you


Attached File : 640471 877621 date project.xlsx downloaded: 222 times
Replies (4)

Just subtract normally , both the dates, as done in the attached file, and change the format of the cells to numbers/accounting.

Sir when i am going to change datesthen  days column shows error i.e. (#value) .

i am not well satiesfied with your trick, please could you tell me step by step with giving instruction 

agree with kumar agarwal

for(#value) increase the cell widtth

Ajay, use below formula. =days360(new date,old date)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 July 2026
Article Assistants

R Shyam and Associates

New Delhi

CA Final

View Details
Company
Featured 18 July 2026
CA Articleship

apricus india

Mumbai

CA Inter

View Details
Company
23 July 2026
CA Inter

Vikram Jadhav and Company

Pune

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
Company
ARTICLESHIP 28 July 2026
Article/Intern/Semi-Qualified/Fresher B.Com

VNSS & Co

Mumbai

Others

View Details
Follow