+ Reply to Thread
Results 1 to 3 of 3

Date formula returns #VALUE

  1. 02-26-2021, 10:23 AM #1
    newtrina
    newtrina is offline
    Registered User
    Join Date
    02-25-2021
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4

    Date formula returns #VALUE

    How can I fix this formula to return blanks instead of #VALUE!

    =DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2))
    Reply With QuoteRegister To Reply
  2. 02-26-2021, 10:31 AM #2
    phatdear
    phatdear is offline
    Registered User
    Join Date
    12-04-2020
    Location
    Bangkok
    MS-Off Ver
    365
    Posts
    61

    Re: Date formula returns #VALUE

    Try this,

    =IFERROR(DATE(LEFT(A2,4),MID(A2,6,2),RIGHT(A2,2)),"")
    Reply With QuoteRegister To Reply
  3. 02-26-2021, 11:11 AM #3
    newtrina
    newtrina is offline
    Registered User
    Join Date
    02-25-2021
    Location
    USA
    MS-Off Ver
    2016
    Posts
    4

    Re: Date formula returns #VALUE

    Yes! Thank you!
    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 check if a date falls within a date range, then returns a corresponding cell
    By pjsween in forum Excel General
    Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  2. IF formula with different returns depending on date
    By benjamin_1986 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2017, 03:23 AM
  3. Date Formula returns #DIV/0
    By rtshort in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 06-04-2016, 10:15 PM
  4. [SOLVED] I need a formula that will allow me to Select a date and add all returns after that date
    By yomamma34 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2016, 09:27 AM
  5. Help with formula that returns a Date Code from a Date
    By mike7952 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2015, 01:28 AM
  6. [SOLVED] I need a formula that looks at a day and a date range and returns the date corresponding
    By john dalton in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-27-2014, 05:38 AM
  7. [SOLVED] Formula that returns the most recent date for a particular year
    By Brian Douglas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-10-2013, 02:02 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