+ Reply to Thread
Results 1 to 2 of 2

Custome Date Fill

  1. #1
    Forum Contributor
    Join Date
    05-31-2013
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2010
    Posts
    170

    Custome Date Fill

    Greetings!

    I'm trying to create a custom date fill for a table. I want to only have the weekdays fill in, and repeats each day twice.

    Like this:
    5/8/2015
    5/8/2015
    5/11/2015
    5/11/2015
    5/12/2015
    5/12/2015
    and so on.

    I know how to get it to fill just the weekdays, but not to repeat. Any ideas?

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    05-31-2013
    Location
    Philadelphia, Pa
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: Custome Date Fill

    Just figured it out!

    As an FYI: do a fill series. Set the date unit to weekday, and set the step value to .5 and it fills just how I wanted.

+ 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. Help with custome sorting
    By cdantonelli in forum Excel General
    Replies: 15
    Last Post: 10-20-2015, 01:45 PM
  2. [SOLVED] custome date "st nd rd th ...."
    By fandi1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-24-2013, 06:18 PM
  3. [SOLVED] Custome formula
    By Sparkplug90 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-15-2013, 03:58 AM
  4. Custome Number Format
    By sp1974 in forum Excel General
    Replies: 4
    Last Post: 04-18-2011, 10:07 AM
  5. Custome AutoFilter
    By nicolachen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2007, 01:53 AM
  6. Custome number format help
    By WB in forum Excel General
    Replies: 2
    Last Post: 07-21-2006, 04:10 PM
  7. Custome Colors?
    By Mark in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2005, 11: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