"Do i make any sense?" - - - - - - No
"it is also getting the same Day as last week"
What is your logic? is it only 06-May-2009 that you want to calculate from?
and many other questions.
Try restating your problem using cell references and fully detail what
results you require.


"Gor_yee" wrote:

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