Sum by Quarter based on date

[day92]

I have a spreadsheet im working on and need some assistance to sum up a qtr based on a specified date that is entered.

I have a spreadsheet attached with the following columns :

Current week - QTD Actual - QTD Budget - Variance - % of Budget

Current week is easy I can do a simple lookup for that but I need assistance with the QTD Actual and the QTD Budget. Based on the date above I need these cell to populate with the correct date. For instance if 4/9 is entered I only need the data for 4/2 and 4/9 and so on until the 3rd Qtr.

Any assistance would be greatly appreciated.

[mdbct]

This will calculate based on calendar year quarters
For the Actual:

Please Login or Register  to view this content.

For the Budget

Please Login or Register  to view this content.

[day92]

mdbct,

thanks for your quick reply. the formula does work but I dont think I was clear in my question.

for instance when I type in a date I only want to get the qtr to date information.

ex -
4/2/10 should produce 0
4/9/10 should produce 20127
4/16/10 should produce 62127

same for budget.

I attached a new spreadsheet is this doable?

Day92

[mdbct]

Try this one:

Please Login or Register  to view this content.

[day92]

Thanks for your help! It works.