Or the shorter

=INT(TODAY()/7)*7+6


--

Regards,

Peo Sjoblom

"Rowan Drummond" <rowanzsaNotThis@hotmail.com> wrote in message
news:OrPkvcf2FHA.2492@TK2MSFTNGP09.phx.gbl...
> Hi Winston
>
> I have translated Jim's code into a worksheet function. Enter in the
> relevant cell:
> =IF(WEEKDAY(TODAY())<>6,TODAY()-WEEKDAY(TODAY())-1,TODAY())
> Note: this is a volatile function, it will be recalculated everytime you
> open, close, save or change the file so that calculation is triggered.
>
> Hope this helps
> Rowan
>
> Winston wrote:
> > Hi Jim
> >
> > Thanks very much for reply, but what does all this mean.
> >
> > I am a new uses seems that my problem will not be sorted.
> >
> > Thanks very much anyway
> >
> > Winston
> >
> >