Can get fg for helpful answers if its alot of work



I want to have it so when I change the date submitted time (top right) 1/19/13 (changing from 18th in the picture) it changes the dates underneath automatically for the previous 2 weeks

i.e. the first week box would say

for the week of: 1/6/13-/1/19/13
and the previous week for the next book

Just make sure the date entered is in it's own cell then for each date you want changed, just put a subtract function for how many days you want.

For example:

Cell B4 would contain:

Cell C4 would contain:


And so on.

actually found one thats a bit longer =IF($G$8="","",$G$8+1) swaping out G 8 for the cell where the date starts than just adding +2 +3 etc as you move on to the consecutive days


thank you for the reply =]