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 <[email protected]>,
68magnolia71 <[email protected]> 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