Windows XP
Excel '07

I have a list of dates-past and future-that will be updated regularly. These
dates will always be a Monday (using Check column and cond. formatting). The
same date could be entered many times.

Sheet Name: DataEntry
(hope this is readable)
Week Start Project Pct Check
11/10/2008 KU-42658 5% Mon
11/10/2008 PKO08007 10% Mon
11/10/2008 PKO08002 20% Mon
11/10/2008 PN08001 2% Mon
11/10/2008 PN08002 5% Mon
11/17/2008 KU-42660 2% Mon
11/17/2008 PKO07987 3% Mon
11/24/2008 PN08003 12% Mon
11/24/2008 PN08004 13% Mon


Sheet Name: ChartData
(will consist of 12 columns (Start Col B) with the first date being the
Monday of the current week). What I'm trying to figure out is how to
'automatically' have the first date be the Monday of the current week (ex,
today is Nov. 7th and I want the first date to show Nov. 3rd). The other 11
dates will just be =B1+7 but I cannot get that first date.

I was think something along the lines of =if(text(today()="Mon",today(),????)

I may be going about this completely wrong, but I'm stuck.

Ultimately, this worksheet will be the basis of a chart. The displayed data
will be a rolling 12 weeks from 'today'. Unfortunately, macros cannot be used.


Thanks in advance.