Thanks Sam,
I think my problem is solved.
Regards,
Suyog
On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote:
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23)
Regards,
Sam Mathai Chacko
On Tue, Nov 15, 2011 at 3:28
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
Please review advice.
Suyog
On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Suyog,
Please see attached sheet.
--
Thanks regards,
Noorain Ansari
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23)
Regards,
Sam Mathai Chacko
On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni suyog.kulka...@yahoo.comwrote:
Hello Noorain,
Thanks for quick response but I've added two problems in same excel.
Hello Friends,
Find attached excel file for ref.
I'm using one software which list out required material for structure in
excel. Output of that excel file converts some length of Ft-In format in
mm-dd-yy or mm-yy format.
Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows