Friday

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

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
>
>

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
> >
> >

Hi Peo

I get the next Friday when I try this, whereas I think the OP wanted the
previous Friday, if today is not a Friday.

Maybe
=TODAY()+CHOOSE(WEEKDAY(TODAY(),-2,-3,-4,-5,-6,0,-1)

Regards

Roger Govier


Peo Sjoblom wrote:
> Or the shorter
>
> =INT(TODAY()/7)*7+6
>
>