banner_ad

How to calculate days between two dates

986 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: 217 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)


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
ARTICLESHIP 30 April 2026
Article Assistant

M/s G.K. Choksi & Co.

New Delhi

CA Inter

View Details
Company
10 May 2026
Finance specialist

Right way solution

Ajmer

CA

View Details
Company
09 May 2026
Audit Manager

Kanna and Associates

Coimbatore

CA Inter

View Details
Company
ARTICLESHIP 05 May 2026
ARTICLED ASSISTANT

JS ADVISORS

New Delhi

CA Inter

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
04 May 2026
Articleship

S.K Gairola & CO

New Delhi

B.Com

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details