+ Reply to Thread
Results 1 to 4 of 4

If Function wit dates

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Spring, Tx
    MS-Off Ver
    Excel 365
    Posts
    66

    If Function wit dates

    I am really stumped on this one. I built this if statement to create a load sheet from another sheet but the dates are entering as a number instead of a date.
    HTML Code: 
    =IF($A3<>"",CONCATENATE(A3,$AG$3,$AI$3,$AG$3,OES!M4,$AG$3,OES!F4))&""
    OES!M4 is a date 03/06/2020 but when it concatenated on the load sheet it looks like this 43896. In the examples below the top is what I'm getting the bottom is what I want.

    0248 - OES CORRECTIVE ACTIONS - 43996 - 510003853
    0248 - OES CORRECTIVE ACTIONS - 03/06/2020 - 510003853

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,483

    Re: If Function wit dates

    How about
    =IF($A3<>"",CONCATENATE(A3,$AG$3,$AI$3,$AG$3,TEXT(OES!M4,"mm/dd/yyyy"),$AG$3,OES!F4))&""

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    Spring, Tx
    MS-Off Ver
    Excel 365
    Posts
    66

    Re: If Function wit dates

    Fluff13, You are Awesome. I tried that but I don't think I put the "

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    8,483

    Re: If Function wit dates

    You're welcome & thanks for the feedback.

+ 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. Instr function and dates, Value of Dates? doubling of results
    By ExcelJWS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2016, 11:38 PM
  2. [SOLVED] Help with Dates between function
    By Big_Slick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2015, 07:41 AM
  3. [SOLVED] Subtracting MONTH Function from another MONTH Function not working for Fiscal dates
    By amartin575 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2013, 10:52 AM
  4. If Function - dates
    By pasleycakes in forum Excel General
    Replies: 5
    Last Post: 12-12-2012, 08:58 AM
  5. COUNTIF function with Dates & due dates.
    By kcowper in forum Excel General
    Replies: 3
    Last Post: 03-10-2011, 12:51 AM
  6. Blank function/Null function for missing dates
    By knowledgeiskey in forum Excel General
    Replies: 2
    Last Post: 05-21-2010, 05:39 PM
  7. if function with dates
    By Brad in forum Excel General
    Replies: 1
    Last Post: 01-10-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1