If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Listed in range A2:B9 are dates and expenses.
How could we total the expenses paid during each quarter in column D?
Solution:
Use the ROUNDUP and MONTH functions to find the dates included in each quarter and sum their matching expenses.
Following is the formula (Array Formula):
{=SUM((C2=ROUNDUP(MONTH($A$2:$A$9)/3,0))*$B$2:$B$9)}
How to find Yearly, Half Yearly and Quarterly due dates ?
Hello !
Can any one help me to solve my problem ?
I have G column for date and F column for mode of payment i.e. Y(yearly),H,(Half Yearly),Q(Quarerly). and M column is due date. i want due date calculations according to Y,H,and Q.
I have G column for date and F column for mode of payment i.e. Y(yearly),H,(Half Yearly),Q(Quarerly). and M column is due date. i want due date calculations according to Y,H,and Q.
The formula should work fine but it's an "array formula" and, as such, needs to be confirmed with CTRL+SHIFT+ENTER
To do this select cell with formula, e.g. D2, press F2 key and then hold down CTRL and SHIFT keys and press ENTER. Curly braces like { and } should appear around the formula in the formula bar.
Linear Mode
