| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting cell and doing date arithmetic
Hi all,
This is probably a simple question for you all. I would like to display the following: dd-mmm-yy to dd+7-mmm-yy for example, for today, the cell should read "13-Jan-2004 to 20-Jan-2004" Any ideas? Thanks, Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Date arithmetic | Excel Discussion (Misc queries) | |||
| Cell not formatting date correctly. | Excel Discussion (Misc queries) | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Row Formatting according to cell date entries. | Excel Discussion (Misc queries) | |||
Threaded Mode
