# Month/quarter/semestre/year calculations

1. ## 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

2. ## 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:
`Please Login or Register  to view this content.`

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

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

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

See the file monthly_Calculations.xlsx

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

#### 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