| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text String Formula Q
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") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a formula into a text string | Excel Discussion (Misc queries) | |||
| Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
| formula for text string | Excel Worksheet Functions | |||
| find text in a string formula | Excel Worksheet Functions | |||
| formula with text string | Excel Discussion (Misc queries) | |||
Threaded Mode
