+ Reply to Thread
Results 1 to 11 of 11

dates for 4 day working week help

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    dates for 4 day working week help

    hi, we work Mon - Thurs and what i want to do is have the dates for these days in a spread sheet ( see example )

    so there are 8 products all with the same date that need carrying on for the next ? years.

    I have manually done it for the example but cant get it to drag down correctly

    any ideas
    Attached Files Attached Files
    Last edited by interested; 02-05-2012 at 12:41 PM.

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: dates for 4 day working week help

    Hi,

    you could write in B34

    =b2+7

    and copy the formula down

    In column A, you should create a custom list from tools (A,B,C,D,E,F,G,Other) option list and then drag down the list.

    Attached an example

    Regards
    Attached Files Attached Files
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: dates for 4 day working week help

    Hi

    Check the attached

    I use supportive column to generate counting from 1 to 8 and then use i function

    Regards
    Attached Files Attached Files
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  4. #4
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Re: dates for 4 day working week help

    Thankyou both for your contributions.

    CANAPONE : i will check that the info is correct, unless you know otherwise. Thanks for the reply. What would i do to the formula to make a 5 day working week?

    Mahju : when i copy the formula down it does not ommit Fri,Sat Sun as in Canapone example i wanted, unless i have done something wrong? Thanks for your reply

    Much appreiciated.

  5. #5
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: dates for 4 day working week help

    Hi just write in B34:B41 January 6 2012 (Friday) and in B42

    =B2+7

    and copy down B42.

    Regards
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Re: dates for 4 day working week help

    Thankyou so much CANAPONE for your quick responce.Ill check it out next week at work and close thread down. Thanks again

  7. #7
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: dates for 4 day working week help

    Hi
    Check this one

    adjusted for Fri, Sat and Sunday

    Regards
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Re: dates for 4 day working week help

    Thanks Mahju for your reply.great stuff. Ill need a clear head for that calculation !!!! can you do one for a five day week too......

  9. #9
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: dates for 4 day working week help

    Hi
    Sure

    See attached

    Regards
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Re: dates for 4 day working week help

    Thanks for the quick reply and other solution !!!

  11. #11
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Re: dates for 4 day working week help

    Dates checkout exactly as required, Thankd guys for the help

+ 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