+ Reply to Thread
Results 1 to 2 of 2

how do i set up a rolling calendar?

  1. #1
    Registered User
    Join Date
    11-03-2017
    Location
    Hampshire
    MS-Off Ver
    excel
    Posts
    3

    how do i set up a rolling calendar?

    Hi all,

    I posted a while ago but didn't find the help i needed...

    Im really hoping someone can help... I'm loosing the will to live... ok so i have a spreadsheet for work. i have set the date so when i change the date all the days and dates change... i want the information in the spreadsheet under the date to only be associated with that date. so when i change the date i want the information to go...and when i put the date back i want the information to come back...

    Does this make sense? I really hope so, I've been trying to solve this for about a month now..
    Thank you
    Attached Files Attached Files
    Last edited by emma-jane2017; 11-17-2017 at 02:56 PM. Reason: title

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: how do i set up a rolling calendar?

    Hi!

    I created a master tab named Test, where I use helper cells in range H2:I3, to deal with overlapping months. You can hide them if desired.

    Then I use this volatile formula to list data from months tabs according to selected date in G3.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Good luck!
    Attached Files Attached Files

+ 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