+ Reply to Thread
Results 1 to 4 of 4

Need VBA to clean date column as format of dd-mmm-yy

  1. 11-17-2022, 09:28 PM #1
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need VBA to clean date column as format of dd-mmm-yy

    Dear Experts

    I have alot of date column which is have issues when doing calculation of date aging its not in proper format.

    i want vba to change date format in columns B:B,D:D,H:H,N:N only depends upon last row A:A value becoz there are no dates in some cells

    find the attachment i want result in same column of input

    regards
    breadwinner
    Attached Files Attached Files
    Last edited by breadwinner; 11-18-2022 at 06:37 AM. Reason: new attachm
    Reply With QuoteRegister To Reply
  2. 11-18-2022, 03:37 AM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: Need VBA to clean date column as format of dd-mmm-yy

    Your file is protected so please submit an unprotected file.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 11-18-2022, 06:38 AM #3
    breadwinner
    breadwinner is offline
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need VBA to clean date column as format of dd-mmm-yy

    Thanks brother for let me know saved me I uploaded new file
    Last edited by breadwinner; 11-18-2022 at 06:39 AM. Reason: wrong title
    Reply With QuoteRegister To Reply
  4. 11-18-2022, 07:06 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,518

    Re: Need VBA to clean date column as format of dd-mmm-yy

    try
    Please Login or Register  to view this content.
    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)

Similar Threads

  1. Convert forced change of date to String or Text format back to Date format in a column
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-20-2022, 09:17 AM
  2. [SOLVED] Trim and/or Clean keep removing the date format of cells
    By rcane in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-22-2021, 10:27 AM
  3. [SOLVED] Need Help Pulling Data Into a Clean Format
    By EdwardSnowden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2019, 09:12 AM
  4. How to clean up and format very messy date data (mix of text and date)
    By RUJedi in forum Excel General
    Replies: 10
    Last Post: 08-09-2017, 02:17 AM
  5. Update given date column in general format to date format in VBA
    By l3sushi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2016, 02:32 PM
  6. Macro to clean up and format report
    By sawan202 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2012, 02:19 PM
  7. Column Range with date Format MM/DD/YYYY independate of sys date Format
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 03:31 AM

Tags for this Thread

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