Hi,
I need help with a formula in Excel.
I Created a worksheet where is possible see the expenses when I select the month, week by week.
But I failed trying to put another formula to show me the period of the week.
Example:
I select month(list): July
Then the Excell show me the expenses per week in columns.
July in cell: A2
Week 1: B4
Expenses 1: B5
Expenses 2: B6
Week 2: C4
Expenses 1: C5
Expenses 2: C6
Week 3: D4
Week 4: E4
The formula that I need is: show the period (date) for each week, something like this:
Week 1: B3 " 07/01 to 07/07"
Week 2: C3 " 07/08 to 07/14"
All those amount about each week is in another "sheet", but in the same WorkSheet.
I really appreciate help for this.
Thank You