Microsoft Excel Find Difference between 2 dates


Common need to find differnce in days,months , years betwen 2 cell datetime values in excel





suppose A2 and A1 are those cells

and We need result on B4

create a Formula on B4 like this


Remember A2 should be a Lesser Date than A1

Replace this d with m for month

Screen shot

Formulas pasted again on adjacent cells

A much simpler wa is there but we cant take month diff and Year difference with,

e. just take =A2-A1 to get datediffernce , if you are enough with dates count

Previous articleChange Desktop Directory in windows 7
Next articleHow to Find My Facebook ID
abhilash, is a programmer by profession and a technology addict with a passion towards browsing , shopping and imaging . My views may be biased on reviews. all images and videos are copyrighted to respective owners.


Please enter your comment!
Please enter your name here