Results 1 to 16 of 16

timeline slicer for months only

Threaded View

  1. #13
    Forum Contributor
    Join Date
    07-13-2015
    Location
    Poland
    MS-Off Ver
    MS Office 365
    Posts
    174

    Re: timeline slicer for months only

    ok,

    now works formula:
    =TEXT(DATEVALUE(M33);"mmmm rrrr")
    when cell M33 contains "Luty 2016" ("Luty" is "February" in polish),

    so it means that I have some settings set to polish. Where I can find it?
    All Excel (menus, formulas, etc.) is in english.

    Is any way to reach this if I have text in english like "January".

    Still do not understand why you have added "1 " before month earlier
    Last edited by zico8; 10-22-2016 at 07:33 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Timeline/Slicer refresh issue
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-02-2016, 10:05 AM
  2. Timeline and Slicer Help
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2016, 06:44 AM
  3. Timeline slicer connection question
    By jugdish in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2015, 02:19 PM
  4. Timeline Slicer showing more months than in data set
    By berkeleyjake in forum Excel General
    Replies: 3
    Last Post: 04-03-2015, 08:12 AM
  5. Slicer Months shows <, > values as well.
    By OldMan62 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-20-2014, 07:17 AM
  6. Adding months to project timeline template
    By learner21 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-25-2014, 12:59 PM
  7. Timeline Slicer custom fiscal period
    By pinebush in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-16-2014, 10:57 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