OK...so at the moment i have the following formula :

=TEXT(TODAY(),"dd-mmm-yyyy") & "," & TEXT(TODAY()-1,"dd-mmm-yyyy") &
"," & TEXT(TODAY()-2,"dd-mmm-yyyy") & "," & TEXT(TODAY()-3,"dd-mmm-
yyyy") & "," & TEXT(TODAY()-4,"dd-mmm-yyyy") & "," & TEXT(TODAY
()-5,"dd-mmm-yyyy") & "," & TEXT(TODAY()-6,"dd-mmm-yyyy") & "," & TEXT
(TODAY()-7,"dd-mmm-yyyy") & "," & TEXT(TODAY()-8,"dd-mmm-yyyy") & ","
& TEXT(TODAY()-9,"dd-mmm-yyyy") & "," & TEXT(TODAY()-10,"dd-mmm-
yyyy") & "," & TEXT(TODAY()-11,"dd-mmm-yyyy") & "," & TEXT(TODAY
()-12,"dd-mmm-yyyy")

my issue is that this formula will refresh everyday, right?? So in
this example..if today's date would be Wednesday 06th May then
obviously the formula wouldnt work as it would take me back to 24-
apr-2009. What my result should be if today is Wednesday 06th May is
that it should display

06-may-2009,05-may-2009,04-may-2009,29-apr-2009,28-apr-2009,27-
apr-2009

If today's date was 05-may, my result should show :

05-may-2009, 04-may-2009, 28-apr-2009,27-apr-2009

as you can see, the dates is always matching the same "weekday" for
this week compared to last week.

Am i making a bit more sense now??





On May 6, 9:04*pm, Ron@Buy wrote:
"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