+ Reply to Thread
Results 1 to 4 of 4

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

  1. 06-16-2021, 10:40 AM #1
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,716

    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
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-16-2021, 11:06 AM #2
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,250

    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!
    Reply With QuoteRegister To Reply
  3. 06-16-2021, 11:11 AM #3
    Howardc1001
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,716

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

    Thanks for the help
    Reply With QuoteRegister To Reply
  4. 06-16-2021, 11:27 AM #4
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    1,250

    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 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. [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. [SOLVED] Date Filter Dropdown - Some in Expandable Year->Month->Day format; others just mm/dd/yyyy
    By mrmotherloving in forum Excel General
    Replies: 3
    Last Post: 06-13-2017, 12:31 PM
  4. [SOLVED] Date Filter Dropdown - Some in Expandable Year->Month->Day format; others just mm/dd/yyyy
    By ashakespeare in forum Excel General
    Replies: 10
    Last Post: 06-13-2017, 09:49 AM
  5. Convert Year to the beginning of the year in dd/mm/yyyy format
    By tannerr12 in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1