I am embarassed to say that I hadent had my glasses on and that what
had thought were * 's...were " 's.... clearly was getting towards th
end of the work shift lol

thanks very much for your help, this new formula is far more concise
it helps alot.

What I would like to do is extend this to acheive my goal. I will tr
to better explain what I am trying to acomplish.

I am making changes to our companys time sheets.
The User enters into T6 the date
in D13 I now have your formula which shows the date for the pay week
end

=IF(T6="**","**",T6+CHOOSE(WEEKDAY(T6),6,5,4,3,2,1,0))

which based on t6 currently reads Saturday May 10 2008

Now Each work day the worker must enter the job number they worked on
and the amount of hours they worked at each job.
so row G is the headings for the days of the week (Monday in G8
Tuesday in G9...Friday in G12)

What I would like to do with these headings is such that when the use
enters the date in T6,  
g8 will ready "Monday May 5th 2008" Tuesday May 6th 2008" and so on.

I am assuming I will just need to make a change of some sort to th
formula you provided me with last time.

Thanks again for the help,
Sea

--
slaga