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
: $$Excel-Macros$$ Delayed Days
Hi All,
I would like to take delayed days from attached file. The formula should
like below.
Colum I - Colum J = Delayed Days
The date format need to be same for further analysis.
Thanks in advance for your support.
Best Regards
Nilesh
Hi All,
I would like to take delayed days from attached file. The formula should
like below.
Colum I - Colum J = Delayed Days
The date format need to be same for further analysis.
Thanks in advance for your support.
Best Regards
Nilesh
P please consider the en
