| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying text during a range of dates
Hi
Just change the "0102" to "0107" in your formula. It would then say New when the date in H1 was 07 Jan -- Regards Roger Govier "RS" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying text during a range of dates
=IF(AND(TEXT($H$1,"MMDD")="0102",TEXT($H1,"MMDD") <="0107"),"New","")
-- David Biddulph "RS" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying text during a range of dates
I think you misunderstood my question. I want the text to be displayed from
January 2nd through January 7th. Changing what you tell me will only display my message on January 7. "Roger Govier" wrote: Hi Just change the "0102" to "0107" in your formula. It would then say New when the date in H1 was 07 Jan -- Regards Roger Govier "RS" wrote in message ... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying text during a range of dates
Thanks David. Works like a charm! Happy new year to you!
"David Biddulph" wrote: =IF(AND(TEXT($H$1,"MMDD")="0102",TEXT($H1,"MMDD") <="0107"),"New","") -- David Biddulph "RS" wrote in message ... 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying text during a range of dates
Apologies. I misread your message. Didn't see range of days.
Luckily David was more awake than I, and gave you the correct solution. -- Regards Roger Govier "RS" wrote in message ... I think you misunderstood my question. I want the text to be displayed from January 2nd through January 7th. Changing what you tell me will only display my message on January 7. "Roger Govier" wrote: Hi Just change the "0102" to "0107" in your formula. It would then say New when the date in H1 was 07 Jan -- Regards Roger Govier "RS" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
