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