+ Reply to Thread
Results 1 to 4 of 4

Formula to extract day.month and year in format dd/mm/yyyy

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,169

    Formula to extract day.month and year in format dd/mm/yyyy

    I have a date in Col A1 as 17 January 2020 I want to extract this in B1 as 17/01/2020

    I used a formula below but get an incorrect answer

    Please Login or Register  to view this content.

    It would be appredciated if someone could assist

  2. #2
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    933

    Re: Formula to extract day.month and year in format dd/mm/yyyy

    The date in A1 is not text, It is formatted to look like text.
    Change format in cell, or use this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Good luck!

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,169

    Re: Formula to extract day.month and year in format dd/mm/yyyy

    Thanks for the help

  4. #4
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    933

    Re: Formula to extract day.month and year in format dd/mm/yyyy

    You're welcome. Glad to help.
    Thank you for the feedback and for the reputation added.
    Have a blessed day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to extract the last or highest month and year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-01-2020, 01:33 AM
  2. [SOLVED] formula to extract month and year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-25-2019, 01:24 PM
  3. Replies: 3
    Last Post: 06-13-2017, 12:31 PM
  4. Replies: 10
    Last Post: 06-13-2017, 09:49 AM
  5. Replies: 4
    Last Post: 02-22-2017, 07:55 PM
  6. Help require to change a year format to custom yyyy-yyyy format
    By mso3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-23-2015, 01:04 AM
  7. Convert Month Day, Year to dd/mm/yyyy
    By Apple Ling in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-30-2013, 07:31 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1