+ Reply to Thread
Results 1 to 9 of 9

Change Date Format from 1 Cell to Another

  1. 07-22-2015, 02:42 PM #1
    karimel_romeo
    karimel_romeo is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    103

    Lightbulb Change Date Format from 1 Cell to Another

    Hi Guys,

    I have a form where users will enter a date in MMM-DD-YYYY format (APR-01-2015) and I need it to populate in another cell in a different format (MM/DD/YYYY).

    Can one of you experts please help? I attach an example:


    Cheers!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-22-2015, 02:52 PM #2
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Change Date Format from 1 Cell to Another

    Try

    =SUBSTITUTE(C7,"-", ", ")+0

    Format the cell with the formula as mm/dd/yyyy
    Reply With QuoteRegister To Reply
  3. 07-22-2015, 03:05 PM #3
    karimel_romeo
    karimel_romeo is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: Change Date Format from 1 Cell to Another

    Yes, that does it, can you please add it with my formula that has the if statement pls? so basically if C7 = blank then blank the cell (as per the attachement)
    Thanks
    Reply With QuoteRegister To Reply
  4. 07-22-2015, 03:09 PM #4
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Change Date Format from 1 Cell to Another

    Try it with C7 blank...
    The formula will be blank as well.
    Reply With QuoteRegister To Reply
  5. 07-22-2015, 03:09 PM #5
    bhenlee
    bhenlee is offline
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Change Date Format from 1 Cell to Another

    here you go:

    =IF(C7="","",SUBSTITUTE(C7,"-",", ")+0)
    If I've helped U pls click on d *Add Reputation
    Reply With QuoteRegister To Reply
  6. 07-22-2015, 03:11 PM #6
    karimel_romeo
    karimel_romeo is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    103

    Re: Change Date Format from 1 Cell to Another

    Awesome both of u! Thx ..solved
    Reply With QuoteRegister To Reply
  7. 07-22-2015, 03:12 PM #7
    bhenlee
    bhenlee is offline
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Change Date Format from 1 Cell to Another

    please mark this thread as Solved if you're satisfied with the solutions provided.
    Reply With QuoteRegister To Reply
  8. 07-22-2015, 03:15 PM #8
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Change Date Format from 1 Cell to Another

    Quote Originally Posted by Jonmo1 View Post
    Try it with C7 blank...
    The formula will be blank as well.
    Woops, that's not right.
    I was playing with other solutions when I did that..

    See bhenlee's adjustment.
    Reply With QuoteRegister To Reply
  9. 07-22-2015, 03:15 PM #9
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Change Date Format from 1 Cell to Another

    Quote Originally Posted by karimel_romeo View Post
    Awesome both of u!
    You're welcome.
    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. Show Error when a cell with number format change to date format
    By delroba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2015, 02:57 AM
  2. How to change a unchageable date cell into a desired date format
    By erickwy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-22-2014, 06:26 PM
  3. Check if the cell format is date and change it to date Format(cell.Value, "yyyy/mm/dd")
    By ccs1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2012, 10:37 AM
  4. [SOLVED] Cell date format wont change
    By tsioumiou in forum Excel General
    Replies: 5
    Last Post: 06-11-2012, 08:44 AM
  5. change date format - recalculate cell value
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2011, 05:37 AM
  6. Change date format of a specific Cell?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2006, 07:02 PM
  7. [SOLVED] Cell date format doesnt change
    By Jon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-07-2006, 12:55 PM

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