+ Reply to Thread
Results 1 to 7 of 7

Date formula

  1. 12-10-2018, 03:15 AM #1
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Date formula

    Dear Friends,
    I need help for date formula.
    I put details in attached file.

    Thank you in advance for your help

    Regards,
    Wie Wie
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-10-2018, 03:29 AM #2
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,281

    Re: Date formula

    Try this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    atul

    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
    Reply With QuoteRegister To Reply
  3. 12-10-2018, 03:33 AM #3
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Re: Date formula

    Hi Atul,
    they become #VALUE!
    Reply With QuoteRegister To Reply
  4. 12-10-2018, 03:40 AM #4
    avk
    avk is offline
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,281

    Re: Date formula

    Remove ' [Single quote] from cell "A3" & format as you required
    Reply With QuoteRegister To Reply
  5. 12-10-2018, 03:41 AM #5
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,411

    Re: Date formula

    remove ' from front of input date
    format A5 Custom format dd-mmm-yyyy
    in cell A5 put =A3 (date then will show as you require).
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 12-10-2018, 03:48 AM #6
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Date formula

    Or try

    =--MID(A3,2,10) custom format to d-mmm-y

    or text
    =TEXT(--MID(A3,2,10),"d-mmm-y")
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  7. 12-10-2018, 07:26 AM #7
    wiewie002
    wiewie002 is offline
    Forum Contributor
    Join Date
    09-07-2015
    Location
    indonesia
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 64-bit
    Posts
    171

    Re: Date formula

    Dear friends,
    Thanks a lot, have been solved with some choices.

    Have a nice day to all of 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 for converting a date to quarter and leaving blank cell for no date values
    By jayc2111 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2019, 12:57 AM
  2. Date formula to return a specific date if todays date is between a date range
    By macquhele in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  3. Formula to Calculate Days Overdue, using Due Date/Date Returned/Extended Date
    By JennGraham in forum Excel General
    Replies: 7
    Last Post: 02-02-2017, 02:41 PM
  4. Formula to figure out the percent up to date based on a date vs. today's date
    By rwelker in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2015, 02:36 PM
  5. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  6. Formula for calculating the date a person will be a certain date from their date of birth
    By zander165 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-03-2014, 10:29 AM
  7. [SOLVED] Help in writing formula in excel to produce dates based on start date and end date
    By shoot for moon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 01:00 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