+ Reply to Thread
Results 1 to 3 of 3

Excel - Sum of Open/Backlog end of each previous month

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2016
    Posts
    25

    Excel - Sum of Open/Backlog end of each previous month

    Hello, I'm looking for a way to calculate the backlog at the end of each previous month.
    In the attached spreadsheet I have some example dates.

    Column "A" Has the open / Start date and time (time is not important)
    Column "B" Contains the Closing date OR is contains NO value when it is still open

    I would like to Add in Column "H'the amount of open (No not closed in the previous month) numbers.
    In the example, I would like to know in "H2" how many items are open of April 2017 at the first of May 1st 2017.
    In "H3", I would like to know how many items are open of April 2017 AND May 2017 at the first of June 1st 2017.
    In "H4", I would like to know how many items are open of April 2017 AND May 2017 AND Jun 2017 at the first of June 1st 2017. (Maybe all Items of April 2017 are closed in May, so not showing anymore)

    All til March 1 2019.

    I hoping for a formula instead of a Marco.

    Thanks upfront to read my request and I'm hoping someone can help me out.
    Attached Files Attached Files
    Last edited by emoes; 09-17-2020 at 10:21 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Excel - Sum of Open/Backlog end of each previous month

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    Amsterdam
    MS-Off Ver
    Excel 2016
    Posts
    25

    Re: Excel - Sum of Open/Backlog end of each previous month

    Sorry, You are right.
    I Made a mistake (the example file was to large and I didn't paid attention to the message hat the file was to large :-)

    Thank you for the reminder.

    Emoes

+ 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. Excel formula to calculate call center backlog
    By rexi01 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 12-21-2021, 11:18 AM
  2. VBA to open the Folder that contains the previous month folder
    By hawk77EF in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2018, 07:08 PM
  3. [SOLVED] Open and show Previous Month
    By tommyfernandez in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 10:59 AM
  4. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  5. Replies: 4
    Last Post: 03-19-2012, 08:58 AM
  6. How to find previous month in excel
    By yourskarthik1983 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2010, 11:10 AM
  7. [SOLVED] why does excel always open the previous files ?
    By Douglas. in forum Excel General
    Replies: 0
    Last Post: 08-17-2006, 07:50 AM

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