Re: Friday

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Not better than Rowan's simply in answer to your question mark:

=TODAY()-WEEKDAY(TODAY(),1)+6+(WEEKDAY(TODAY())=7)*7

--
Regards,


Sandy
sandymann@xxxxxxxxxxxxxx
Replace@mailinator with @tiscali.co.uk


"Winston" <Winston.1xizif_1130357149.6452@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Winston.1xizif_1130357149.6452@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi All
>
> Cannot believe how helpful you all are, thanks very much but.
>
> we have a winner Rowen, I copy and pasted his formula and it the only
> one that works so far?.
>
> ;) :)
>
> Thanks Again All.
>
> Winston.
>
>
> --
> Winston
> ------------------------------------------------------------------------
> Winston's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=28344
> View this thread: http://www.excelforum.com/showthread.php?threadid=479278
>


.

Relevant Pages

  • RE: Data exchange over wireless (best practice)
    ... "Smiljan" wrote: ... > Hi Winston! ... > Thanks again and best regards, ... >>> are to exchange data with database server. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Last Working Day In Month
    ... Without having to install the Analysis Toolpak try: ... HTH ... Sandy ... > Winston. ...
    (microsoft.public.excel.newusers)
  • Re: Java based remote desktop Control
    ... I am having a project named java remote desktop control for sale.For ... with regards ...
    (comp.lang.java.softwaretools)
  • Re: Last Working Day In Month
    ... Doesn't look so good now Sandy ... >> Winston's Profile: ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Friday
    ... Regards ... Winston ... Winston's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28344 ... Prev by Date: ...
    (microsoft.public.excel.newusers)