+ Reply to Thread
Results 1 to 3 of 3

Custom date filter for next twelve months from a specific date

  1. #1
    Registered User
    Join Date
    07-16-2012
    Location
    newcastle , england
    MS-Off Ver
    excel 2010
    Posts
    10

    Custom date filter for next twelve months from a specific date

    Hi,

    Got a meeting on monday at work and need to find out how to set up the company job list excel file to show the current workload for the next twelve months from the current date.

    Can anyone help?

    I've attached the file in question with some of the sensitive data removed.

    The main fully functioning workbook has a few buttons that are shown on the top of the attached workbook which run some of the date filters in the filter options. One really important one for my meetings would be for the workbook to, at the click of one of the macro buttons, show the workload for the year ahead based on the date in the input box at the top right of the table.

    I know there is a next year filter but that starts from Jan every year doesn't it?

    Can anyone help me with this?

    Thank you

    Andrew
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2003
    Posts
    4,168

    Re: Custom date filter for next twelve months from a specific date

    hi Andrew, code to be assigned to a new button for workload 1 year ahead:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-16-2012
    Location
    newcastle , england
    MS-Off Ver
    excel 2010
    Posts
    10

    Re: Custom date filter for next twelve months from a specific date

    Thank you very very much!

    Brilliant help!

    Regards

    Andrew

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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