Hello Nilesh,
Another way, K2 copy down.
=TEXT(I2,"\/00\/00")-TEXT(J2,"\/00\/00")
If you don't want to see -days use
=ABS(TEXT(I2,"\/00\/00")-TEXT(J2,"\/00\/00"))
Or,
convert the Dates to actual date, for doing this,
Select the whole column I:I, go to,
Data >> Text to
Thanks it's works.
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma
Sent: Wednesday, July 13, 2011 1:20 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Delayed Days
Use this in K2
=-(DATE(LEFT(I2,4),MID(I
Use this in K2
=-(DATE(LEFT(I2,4),MID(I2,5,2),RIGHT(I2,2))-DATE(LEFT(J2,4),MID(J2,5,2),RIGH
T(J2,2)))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Virkar,Nilesh
Sent: Wednesday, July 13, 2011 12:40 PM
To: excel-macros@googlegroups.com
Subject: $$Excel