+ Reply to Thread
Results 1 to 4 of 4

Fill dates with weekdays/workdays only

  1. #1
    DJ Bjorklund
    Guest

    Fill dates with weekdays/workdays only

    How do I fill a column's cells with a year's worth of weekdays only?
    TIA

  2. #2
    JE McGimpsey
    Guest

    Re: Fill dates with weekdays/workdays only

    Enter the first date. Right-click the fill handle in the lower right
    corner of the cell and drag down about 270 rows. Choose Fill Weekdays
    from the menu that pops up when you release the mouse.

    In article <[email protected]>,
    DJ Bjorklund <[email protected]> wrote:

    > How do I fill a column's cells with a year's worth of weekdays only?
    > TIA


  3. #3
    Gilbert De Ceulaer
    Guest

    Re: Fill dates with weekdays/workdays only

    Set 1ste weekday in H29 (in 2005 : "03/01/2005")
    then in h30->h(as much as you like):
    =IF(WEEKDAY(H29;2)=6;H29+3;IF(WEEKDAY(H29;2)=7;H29+2;H29+1))
    OK ?
    Gilbert


    "DJ Bjorklund" <[email protected]> wrote in message
    news:[email protected]...
    > How do I fill a column's cells with a year's worth of weekdays only?
    > TIA




  4. #4
    Registered User
    Join Date
    01-31-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Fill dates with weekdays/workdays only

    Quote Originally Posted by JE McGimpsey View Post
    Enter the first date. Right-click the fill handle in the lower right
    corner of the cell and drag down about 270 rows. Choose Fill Weekdays
    from the menu that pops up when you release the mouse.

    In article <[email protected]>,
    DJ Bjorklund <[email protected]> wrote:

    > How do I fill a column's cells with a year's worth of weekdays only?
    > TIA
    Hi, I am new to this, okay can fill my excel 2007 column with weekday dates for the year, but how do I fill it with double dates for each date, ie 4 Feb 4 Feb 5 Feb 5 Feb etc etc.. and other column with Mon Mon Tue Tue Wed Wed week days only? Thank you.
    JMGC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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