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 |
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 |
All times are GMT +1. The time now is 07:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com