R RAFI Member Feb 6, 2017 #1 Hi all, i have two dates in two column. in one column i have product receive date SAY 02/25/2010. in another column 02/04/2017. i want to know exactly how many years,months,days gone from 0204/17 since it is received . thanks
Hi all, i have two dates in two column. in one column i have product receive date SAY 02/25/2010. in another column 02/04/2017. i want to know exactly how many years,months,days gone from 0204/17 since it is received . thanks
N Nabeel Member Feb 6, 2017 #2 Hi try this Code: =DATEDIF(A2, B2, "y") &" years, "&DATEDIF(A2, B2, "ym") &" months, " &DATEDIF(A2, B2, "md") &" days"
Hi try this Code: =DATEDIF(A2, B2, "y") &" years, "&DATEDIF(A2, B2, "ym") &" months, " &DATEDIF(A2, B2, "md") &" days"
