+ Reply to Thread
Results 1 to 3 of 3

Calculate a YTD Total based on Reporting Month and Week of Month via drop down selections

  1. #1
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Calculate a YTD Total based on Reporting Month and Week of Month via drop down selections

    Lo all,

    I am stuck on calculating a YTD budget total dependent on both what month we're reporting on and the week. For instance, if we were reporting on the first week of March, we'd want to total both Jan & Feb w/ a quarter of the March budget.

    I have a feeling it's something stupid simple, but I am just not seeing it at this time.

    Much appreciated friends.

    -Kondukt

    YTDBudgetTotalExample.png
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,676

    Re: Calculate a YTD Total based on Reporting Month and Week of Month via drop down selecti

    Take a look at the attached.
    I had to change format of Months in column D and added a drop down in H1 to select Month.
    That helps with month comparison in the formula in I5 and I6.
    Hope this works for you.
    Attached Files Attached Files
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Contributor
    Join Date
    01-19-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Office 365 2016
    Posts
    214

    Re: Calculate a YTD Total based on Reporting Month and Week of Month via drop down selecti

    That did indeed, thank you good sir. Rep added

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Week number in month determined by 3/4 weekdays in week within said month
    By atearth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2017, 02:36 PM
  2. Macro to calculate Month to year sales based on month selection
    By chandu356 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2017, 09:58 AM
  3. Days of the month and week based on name month/year
    By RickMcc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2016, 03:22 PM
  4. [SOLVED] Calculate Week Range from Week Number, Month and Year?
    By A108A108 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-07-2016, 03:11 PM
  5. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM
  6. [SOLVED] Showing Fridays of each month in a 4 week month and a five week month
    By david_j_p in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2013, 06:27 AM
  7. [SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period
    By jeversf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 12:10 PM

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