I need one that will use excel to figure what is today's date in the
"dd-mmm-yyyy" format as well as same day last week. For example,

if today was Wednesday 06-May-2009, I need it to return the following
data, 06-may-2009,04-may-2009,03-may-2009,29-apr-2009,28-apr-2009,27-
apr-2009. As you can see, it is also getting the same Day as last
week. I need it to also validate that if today is not Thursday 07-
may-2009 yet then it wont return me data for the 30-apr-2009. Do i
make any sense?

thanks heaps