+ Reply to Thread
Results 1 to 2 of 2

Rolling 30 days

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Rolling 30 days

    hey guys,

    I have been struggling to get this problem done:

    There are 3 columns,
    1st column: 1000 dates (for example: 1/02/05(taking this as Monday), 2/02/05(tuesday), 3/02/05, 4/02/05, 5/02,05, 8/02/05(monday), etc...) where weekends and public holidays are not included.
    2nd column: 1000 values (for example: 20, 21, 26, 30, 10, 9 etc...)
    3rd column: change (21-20 = 1, 26-21=5,...., 9-10=-1. etc...)

    All i need to do is find the total change in for monthly moves (not calender months). for example, 15/06/05 - 15/07/05.
    Since the weekends and public holidays are not included in the dates, i am really confused.. Need help getting the formula too

    Hope someone could assist me with this.
    Thank you so much!!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Rolling 30 days

    Hi burningice,

    welcome to the forum.
    Can you upload a sample workbook along with your expected results? Thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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