Re: $$Excel-Macros$$ SOLVE THIS

Try =DATE(20RIGHT(A1,2),MID(A1,4,2),MID(A1,2,2)) It will convert the string as date On 2/27/15, Sam Mathai Chacko samde...@gmail.com wrote: =--TEXT(RIGHT(A1,6),00\/00\/00) On 27 Feb 2015 11:47, sush.dav...@gmail.com wrote: I have a data like below where I need only date. S270215 R270215

$$Excel-Macros$$ Dose any one have any capacity tracker

Hi Friends, Dose any one have any template or format for a capacity tracker, to provide the teams available capacity project and day wise. Thanks a lot!!! Regards, Mayank -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Need a reporting template for manufacturing company

Hi All, I need some reporting template for manufacturing company (all kinds of analysis which we can perform for a manufacturing company). appreciate your response. Regards, Mayank -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Array If

Hi Hanumant, use it like IF($A$8 =a,1,) and drag the formula till A14 or till last row it will give u 1 only if the cell will contain a. Try this out. Rgds, Mayank On Mon, Jan 17, 2011 at 1:03 AM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Hi Friends, I want to use IF condition like i