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: 225 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 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
28 August 2026
Assistant Manager

NRS AND ASSOCIATES

Kozhikode

CA Inter

View Details
Company
28 August 2026
Audit Manager

K A R M & CO

Mumbai

CMA

View Details
Company
ARTICLESHIP 24 August 2026
Article Assistant

M/s.S.G.Salecha & Co.

Mumbai

CA Inter

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details
Company
04 September 2026
CA inter Or ca finalist

A Jaiswal and company

Lucknow

CA Final

View Details
Company
18 August 2026
CA Semi Qualifies

Goyanka and Associates

New Delhi

CA Inter

View Details