+ Reply to Thread
Results 1 to 2 of 2

Month/quarter/semestre/year calculations

  1. #1
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Month/quarter/semestre/year calculations

    Hello everyone
    Here's a tuff one, for me for sure

    I have like a thousand records that shows me for each client the periode of invoice. That periode can be monthly, quarterly, semestre and anual.
    The question is: Since he started the agreement on a particular month, would i send him an invoice on another month, depending on the periode.
    For example: if a client like to receive an invoice 2 times a year (semestre) and he started on Mar-16, the next invoice will be on Sep-16. I have to ask, not only what kind of periode do we have, but also, is this month, the month that i have to send him an invoice.
    Let me add an example file, maybe you can help me.
    Many thanks for all your help
    Best regards
    Pedro
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Month/quarter/semestre/year calculations

    Olá Pedro
    Considere the following table (in same sheet for example)
    B22:B25 --> M A S T
    C22:C25 --> 1 12 2 4
    D22:D24 --> 1 1 6 3

    Use the following formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

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

    and copy right and down
    You can use as alternative
    Formula: copy to clipboard
    Please Login or Register  to view this content.

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


    See the file monthly_Calculations.xlsx

+ 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. Replies: 4
    Last Post: 08-05-2015, 06:39 PM
  2. [SOLVED] Using SumProduct for dates inclusive of Year to Date, Month to date, Quarter to Date
    By cartica in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2014, 04:22 PM
  3. [SOLVED] Help a poor SEN teacher out! Year:Month calculations :/
    By heisenburg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-24-2013, 03:26 PM
  4. Expanding 4th quarter by month ONLY for certain year
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-28-2013, 06:13 PM
  5. [SOLVED] PIVOT TABLES: Grouping dates by Fiscal Year, Quarter and Month
    By bimmer5dude in forum Excel General
    Replies: 5
    Last Post: 06-30-2012, 09:13 PM
  6. Replies: 9
    Last Post: 11-16-2009, 07:16 PM
  7. [SOLVED] maturity schedule fixed inc securities by month, quarter and year
    By maturity schedule in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2006, 07: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