+ Reply to Thread
Results 1 to 3 of 3

how to fill in 2014's weekdays range automatically?

  1. #1
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    136

    how to fill in 2014's weekdays range automatically?

    hi guys,
    i had a problem to fill in weekdays of 2014 excluding friday and saturday as holidays.please help me..
    example included..weekdayrange.xlsx

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: how to fill in 2014's weekdays range automatically?

    In cell A4, enter:

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


    Copy down.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    07-08-2012
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    136

    Red face Re: how to fill in 2014's weekdays range automatically?

    thank you so much..

+ 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. Fill dates with weekdays/workdays only
    By DJ Bjorklund in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2013, 12:05 PM
  2. Replies: 1
    Last Post: 10-29-2009, 02:30 AM
  3. [SOLVED] Automatically renaming worksheets to weekdays
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2006, 08:20 AM
  4. Automatically update column with weekdays
    By Maddoktor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2006, 03:35 PM
  5. Creating a year of weekdays automatically?
    By waterskyle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2006, 03:30 PM

Tags for this Thread

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