| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying text during a range of dates
Happy New Year everyone! I currently have formulas that display different
formatted text in cells when certain months & days occur (regardless of the year). I would like to modify one of the formulas such that I could display a text message over a range of consecutive days. Here is my current formula [where H1 displays todays date (1/2/07 for example): =IF(TEXT($H$1,"MMDD")="0102","New","") How would I modify this such that I could display this message from, let's say 0102 to 0107? I'm using Excel 2003 & 2000. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| Dates formatted as text | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Text with Dates | Excel Discussion (Misc queries) | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Threaded Mode
