Re: Text String Formula Q
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Thu, 23 Oct 2008 01:12:35 -0700 (PDT), Seanie <seanryanie@xxxxxxxxxxx>
wrote:
I have the formula below that returns the string "Sales for w/e
19/10/08" - depending of course what the value Today()-1 is. How could
I modify that if Today()-1 is anything other than a Sunday value, it
would return the date of the previous Sunday to the one I am now in?
E.g. Today()-1 is 22/10/08 but I would want the date returned as
19/10/08
="Sales for w/e "&TEXT((TODAY()-1),"dd/mm/yy")
A general formula would be:
=A1+1-WEEKDAY(A1)
So, in your string, substitute for A1, TODAY()-1.
e.g.
="Sales for w/e "&TEXT((TODAY()-WEEKDAY(TODAY()-1)),"dd/mm/yy")
--ron
.
Relevant Pages
- Re: Protecting a field within a form
... Public Function IsUserInGroup(strGroup As String, ... "John Nurick" wrote: ... display the fields you don't want the users to be able to modify. ... John Nurick [Microsoft Access MVP] ...
(microsoft.public.access.gettingstarted) - Re: How to convert Infix notation to postfix notation
... and make all strings const save where the intent ... function whose contract is to change the string. ... try to do using the pointer you get. ... but that you cannot modify the things pointed to by p. ...
(comp.lang.c) - Re: string upper, string lower, string subthisforthat
... | allowed to modify any elements of the input elements. ... | sequence operations section of the Standard. ... | that the sequence is not allowed to be modified. ... | error to leave out case insensitive string comparisons. ...
(alt.comp.lang.learn.c-cpp) - Re: Open folders to process files automatically
... Move it, Copy it, Read it, Modify it, Delete it. ... Dim AllFoldersAs String = Directory.GetDirectories ... Dim AvailableFiles() As String ... open each file with in the folder individually and process each one. ...
(microsoft.public.dotnet.languages.vb) - Re: Web part question in 2007
... - that the user will be able to modify by clicking "Modify shared web ... Description("Sharepoint list name to bind to"), ... Public Property ContentList(ByVal name As String) As String ...
(microsoft.public.sharepoint.portalserver) |
|
