How to calculate days between two dates

859 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: 184 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