Hi everyone.
Im working on a spreadsheet that basically needs to find the total budget between two dates.
Weeks for this work starts on Saturday,
So I need to calculate: SATURDAY (thru to) TODAY for total budget.
And both Saturday and today need to be variables that are not set in the spreadsheet if possible.
Any help? Basicly my spreadsheet looks like this:
Im working on a spreadsheet that basically needs to find the total budget between two dates.
Weeks for this work starts on Saturday,
So I need to calculate: SATURDAY (thru to) TODAY for total budget.
And both Saturday and today need to be variables that are not set in the spreadsheet if possible.
Any help? Basicly my spreadsheet looks like this:
Code:
A B
-- ----
DATE BUDGET
-- -----
1| 06-Jun-11 500
2| 07-Jun-11 300
Last edited: