How to calculate days between two dates

997 views 4 replies

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: 220 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 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
24 June 2026
Chartered Accountant - GST & Direct Tax

APL

Mumbai

CA

View Details
Company
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details