$$Excel-Macros$$ Re: Date Format Query

2014-06-14 Thread GENIUS
look at the result -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Re: date format

2012-02-27 Thread NOORAIN ANSARI
Awesom Logic Haseeb... On Mon, Feb 27, 2012 at 8:19 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hi Lee, try > > For the Week, > > =WEEKNUM(TEXT(A1,"\-00\-00")) > > For the month, > > =TEXT(TEXT(A1,"\-00\-00"),"") > > HTH > Haseeb > > -- > FORUM RULES (986+ members

Re: $$Excel-Macros$$ Re: date format

2012-02-26 Thread Maries
Great... Powerful Logic. On Mon, Feb 27, 2012 at 6:49 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hi Lee, try > > For the Week, > > =WEEKNUM(TEXT(A1,"\-00\-00")) > > For the month, > > =TEXT(TEXT(A1,"\-00\-00"),"") > > HTH > Haseeb > > -- > FORUM RULES (986+ members al

$$Excel-Macros$$ Re: date format

2012-02-26 Thread Haseeb Avarakkan
Hi Lee, try For the Week, =WEEKNUM(TEXT(A1,"\-00\-00")) For the month, =TEXT(TEXT(A1,"\-00\-00"),"") HTH Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

$$Excel-Macros$$ Re: Date Format

2009-10-01 Thread Paul Schreiner
nents into (3) columns, which you can then re-assemble. Paul From: Chandra Gupt Kumar To: excel-macros@googlegroups.com Sent: Thursday, October 1, 2009 8:25:41 AM Subject: $$Excel-Macros$$ Re: Date Format Alternatively, Do the following, 1. Select the c

$$Excel-Macros$$ Re: Date Format

2009-10-01 Thread Chandra Gupt Kumar
dey Sent: Thursday, October 01, 2009 9:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Date Format Hi Kaustubh, If you have these dates in column A, then try the following formula in column B and drag it down. Thanks. =DATE(RIGHT(A1,2),MID(A1,FIND(".",A1)

$$Excel-Macros$$ Re: Date Format

2009-09-30 Thread Dilip Pandey
Hi Kaustubh, If you have these dates in column A, then try the following formula in column B and drag it down. Thanks. =DATE(RIGHT(A1,2),MID(A1,FIND(".",A1)+1,FIND(".",A1,2)-1),LEFT(A1,FIND(".",A1)-1)) Solved workbook is also attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.

$$Excel-Macros$$ Re: Date Format

2009-09-30 Thread Kaustubh K
Hey Abhishek, In fact when I tried later, I found that your suggetion works. When I replaced . with / it automatically gave me the date format dd/mm/. And once I got that it is very easy to convert it in mm/dd/yy. Great ! Thanks On Sep 30, 9:48 am, Abhishek Jain wrote: > Hi Kaustubh, > > Sor

$$Excel-Macros$$ Re: Date Format

2009-09-30 Thread Upendra Singh
-Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Kaustubh K Sent: Tuesday, September 29, 2009 9:10 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Date Format Hi Abhishek, Thanks for your reply ! But there is on

$$Excel-Macros$$ Re: Date Format

2009-09-29 Thread Abhishek Jain
Hi Kaustubh, Sorry I missed the mmdd part of your query. By the way Paul's solution is working great! Attached is a sample file. Brgrds On Tue, Sep 29, 2009 at 9:10 PM, Kaustubh K wrote: > > Hi Abhishek, Thanks for your reply ! But there is one problem. Suppose > I have date 5.6.08 ( June

$$Excel-Macros$$ Re: Date Format

2009-09-29 Thread Sandeep
ot; To: "MS EXCEL AND VBA MACROS" Sent: Tuesday, September 29, 2009 9:10 PM Subject: $$Excel-Macros$$ Re: Date Format Hi Abhishek, Thanks for your reply ! But there is one problem. Suppose I have date 5.6.08 ( June 5, 08). If I replace . by / then I ll get 5/6/08 date format is mmddyy

$$Excel-Macros$$ Re: Date Format

2009-09-29 Thread Kaustubh K
Hi Abhishek, Thanks for your reply ! But there is one problem. Suppose I have date 5.6.08 ( June 5, 08). If I replace . by / then I ll get 5/6/08 date format is mmddyy and my date will change and it will be May 6,08. On Sep 28, 3:02 pm, Abhishek Jain wrote: > Easy and simple - > > Select your co

$$Excel-Macros$$ Re: Date Format

2009-09-29 Thread Kaustubh K
Hi Paul, Thanks for your reply. I tried this. It is showing #VALUE! On Sep 28, 4:26 pm, Paul Schreiner wrote: > since the values are always 2 characters, > you could add a column and use: > > =DATEVALUE(MID(A2,4,2)&"/"&LEFT(A2,2)&"/"&RIGHT(A2,2)) > > hope this helps > > Paul > > ___

$$Excel-Macros$$ Re: Date Format

2009-09-28 Thread Abhishek Jain
Easy and simple - Select your column and press Ctrl+H (replace) put *.* in find what and put * /* in replace with...click replace all. you're done. On Mon, Sep 28, 2009 at 1:27 PM, Kaustubh K wrote: > > Hi, > > I have around 500 entries which have format of date dd.mm.yy say > 21.05.08 ( And t

$$Excel-Macros$$ Re: Date Format

2009-09-28 Thread Paul Schreiner
since the values are always 2 characters, you could add a column and use: =DATEVALUE(MID(A2,4,2)&"/"&LEFT(A2,2)&"/"&RIGHT(A2,2)) hope this helps Paul From: Kaustubh K To: MS EXCEL AND VBA MACROS Sent: Monday, September 28, 2009 3:57:05 AM Subject: $$Excel-M