| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Warning message base on date
I want a message appear on a sheet of a worksheet, base on a date.
For example: the message "send weekly file" should appear somewhere on the page, or in a dedicated cell, each wednesday. Is there a way ( functions and/or VBA, prefer functions!) to achieve the goal? Thanks for any help 68magnolia71 |
|
#2
|
|||
|
|||
|
One way:
=IF(WEEKDAY(TODAY())=4,"send weekly file","") In article , 68magnolia71 wrote: I want a message appear on a sheet of a worksheet, base on a date. For example: the message "send weekly file" should appear somewhere on the page, or in a dedicated cell, each wednesday. Is there a way ( functions and/or VBA, prefer functions!) to achieve the goal? Thanks for any help 68magnolia71 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date formula | Excel Discussion (Misc queries) | |||
| Problem with date base units for x axis | Charts and Charting in Excel | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
