Microsoft Excel Find Difference between 2 dates

0
6

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

 

Steps

 

 

suppose A2 and A1 are those cells

and We need result on B4

create a Formula on B4 like this

=DATEDIF(A2,A1,”d”)

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

SHARE
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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here