Formula question help regarding calculating future dates

[squirrellygirl]

I am trying to set up a formula that will allow me to calculate the following information:
Each Monday I need to run a report that will calculate information from the coming Thursday minus three weeks to the coming Wednessday minus two weeks.

Date examples would be
Report run on March 17 for date of March 6-March 12

To me this is a complex formula (I'm pretty new to excel formulas), and could use some help.

I'd appreciate any imput.

Thanks!
Sheryl

 

[Comfy]

You will need to post a sample of your data as your question is very ambiguous.

 

[npvrader]

You would use date math. When you add or subtract integers from a date, you get another date. Since what you are describing is that you every Monday, you want to calculate the reporting date range on a fixed basis (2 Wednesdays prior, to the following Thursday (one Thursday prior). This means that the report range will always be from 11 days ago through 5 days ago or for a period of 7 days....So, if you had the following
in A1 3/17/14
in b1 the following formula A1 - 11
in C1 the following formula A1 - 5

Everytime A1 changes it will recalculate b1 and c1

 

[squirrellygirl]

Thanks! I was making it too complicated and trying to make the dates appear in the same cell.

You would use date math. When you add or subtract integers from a date, you get another date. Since what you are describing is that you every Monday, you want to calculate the reporting date range on a fixed basis (2 Wednesdays prior, to the following Thursday (one Thursday prior). This means that the report range will always be from 11 days ago through 5 days ago or for a period of 7 days....So, if you had the following
in A1 3/17/14
in b1 the following formula A1 - 11
in C1 the following formula A1 - 5

Everytime A1 changes it will recalculate b1 and c1