+ Reply to Thread
Results 1 to 5 of 5

build business days calendar

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    23

    build business days calendar

    Hello everyone,

    I have the attached business days calendar with manually inserted values and every year I have to modify it manually.
    There is any way (formula) to build it automatically every year?

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,803

    Re: build business days calendar

    I could set this up for you so that you enter the first working day of the year in A4 and then it automatically generates all the other dates - is this what you want?

    Pete

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    23

    Re: build business days calendar

    this would be great

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,803

    Re: build business days calendar

    Okay, the attached file does this for you. Just put the date of the first working day of the year in cell A4 (coloured yellow, and formatted to show the year) and it will automatically adjust.

    Hope this helps.

    Pete
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-21-2012
    Location
    Romania
    MS-Off Ver
    2010
    Posts
    23

    Re: build business days calendar

    I don't understand your formulas but it works great.
    Thank you very much, Pete!

+ 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