Results 1 to 4 of 4

Formula to Extract month and year from Text

Threaded View

Howardc1001 Formula to Extract month and... 06-29-2022, 08:26 PM
wk9128 Re: Formula to Extract month... 06-29-2022, 09:22 PM
Howardc1001 Re: Formula to Extract month... 06-29-2022, 10:08 PM
wk9128 Re: Formula to Extract month... 06-29-2022, 10:12 PM
  1. 06-29-2022, 08:26 PM #1
    Howardc1001 is offline
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2024
    Posts
    2,873

    Formula to Extract month and year from Text

    I have text in Cell A1 and it contains a date at the end fore eg 31 May 2022


    I have used a formula to extract the month and year below but if the date at the end is for eg 30 April 2022, it returns #value


     =DATEVALUE(RIGHT(A1,12))

    It would be appreciated if someone could kindly amend my formula
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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 MONTH ANd year from a number
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2021, 09:02 PM
  2. [SOLVED] Formula to extract day.month and year in format dd/mm/yyyy
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2021, 11:27 AM
  3. [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
  4. [SOLVED] formula to extract month and year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-25-2019, 01:24 PM
  5. [SOLVED] How to extract year and month from a date and combine them into a text
    By billj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2017, 09:24 AM
  6. [SOLVED] Extract Day, Month and Year from a text box (user input) date value
    By HeyInKy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-01-2014, 10:40 PM
  7. [SOLVED] Extract Text from String then Convert to a Date (Month/Year)
    By sgrey24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2013, 06:11 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