+ Reply to Thread
Results 1 to 6 of 6

How to convert dates into Dutch day names (English Excel version)

  1. #1
    Registered User
    Join Date
    11-08-2016
    Location
    Netherlands
    MS-Off Ver
    Excel for Mac 15.32, English version
    Posts
    26

    How to convert dates into Dutch day names (English Excel version)

    One of my columns contains dates. For the English locale dates can be formatted to show the day names. However, this option is lacking for the Netherlands locale. I tried using the function =TEXT(B1; "dddd") to convert dates to day names, but they are in English – even if the dates are formatted for the Netherlands locale. Is there any way to have the day names displayed in Dutch, other then by doing find&replace?

    I'm using the English version of Excel for Mac 15.32.

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: How to convert dates into Dutch day names (English Excel version)

    Maybe :
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Registered User
    Join Date
    11-08-2016
    Location
    Netherlands
    MS-Off Ver
    Excel for Mac 15.32, English version
    Posts
    26

    Re: How to convert dates into Dutch day names (English Excel version)

    Great, Thank you!

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: How to convert dates into Dutch day names (English Excel version)

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    11-08-2016
    Location
    Netherlands
    MS-Off Ver
    Excel for Mac 15.32, English version
    Posts
    26

    Re: How to convert dates into Dutch day names (English Excel version)

    Done: marked as solved!

  6. #6
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: How to convert dates into Dutch day names (English Excel version)

    Thanks for doing that (marking solved) and rep.points.

    Regards

+ 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. How to convert Urdu Names into Roman English
    By Dextor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2015, 12:02 PM
  2. Replies: 8
    Last Post: 02-12-2015, 07:32 AM
  3. Convert Excel in English to French version
    By ahng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2012, 03:48 PM
  4. Replies: 1
    Last Post: 04-04-2009, 08:23 AM
  5. Macro won't loop in Dutch version
    By eboogie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2008, 06:14 PM
  6. Replies: 1
    Last Post: 10-09-2005, 12:05 PM
  7. Replies: 1
    Last Post: 08-23-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1