+ Reply to Thread
Results 1 to 7 of 7

Macro to convert require date format

  1. 06-13-2013, 01:26 AM #1
    rvkadu1
    rvkadu1 is offline
    Registered User
    Join Date
    05-08-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Macro to convert require date format

    I have fuel consumption data in which dates (in B Column) are not in date format, i would like to change the format into require date format

    further populate missing dates from provided range in b colum into E where data is end. in given example missing dates are as follows in the provided date range (B Column);
    1-Feb-13
    3-Feb-13
    8-Feb-13
    10-Feb-13
    11-Feb-13
    12-Feb-13
    14-Feb-13
    17-Feb-13
    19-Feb-13
    20-Feb-13
    21-Feb-13
    24-Feb-13
    26-Feb-13
    28-Feb-13


    Please ref. attached for details.

    RAV
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-13-2013, 07:00 AM #2
    rvkadu1
    rvkadu1 is offline
    Registered User
    Join Date
    05-08-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Macro to convert require date format

    Please help me !!!
    Reply With QuoteRegister To Reply
  3. 06-14-2013, 01:38 AM #3
    rvkadu1
    rvkadu1 is offline
    Registered User
    Join Date
    05-08-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Macro to convert require date format

    Quote Originally Posted by rvkadu1 View Post
    Please help me !!!

    I am sure you Excel Master will resolve my query

    R
    Reply With QuoteRegister To Reply
  4. 06-14-2013, 07:59 AM #4
    djdjdj
    djdjdj is offline
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Macro to convert require date format

    This is an attempt done largely with the recorder. I thought your problem was interesting so I took a stab at it. 

    Please Login or Register  to view this content.
    I'm sure a more advanced user will provide a better solution, but you're probably not helping your cause by screaming for help. Have some patience
    Last edited by djdjdj; 06-14-2013 at 08:06 AM.
    Reply With QuoteRegister To Reply
  5. 06-17-2013, 05:55 AM #5
    rvkadu1
    rvkadu1 is offline
    Registered User
    Join Date
    05-08-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Macro to convert require date format

    Macro running & giving some resultes,
    only Missing 2 Dates not appearing (1st of the Month & last of the Month)
    1st Feb'2013 & 28th Feb'2013
    Reply With QuoteRegister To Reply
  6. 06-17-2013, 07:00 AM #6
    djdjdj
    djdjdj is offline
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Macro to convert require date format

    try this...

    Please Login or Register  to view this content.
    Last edited by djdjdj; 06-17-2013 at 07:04 AM.
    Reply With QuoteRegister To Reply
  7. 06-17-2013, 07:08 AM #7
    rvkadu1
    rvkadu1 is offline
    Registered User
    Join Date
    05-08-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Macro to convert require date format

    Thanks a lot Sir, it's working fine
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1