View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Is there a way to add monthly message to excel

Add a worksheet.
Put 1 to 12 in A1:A12
put your messages in B1:B12

=vlookup(month(today()),sheet2!a:b,2,false)

to retrieve that message based on today's month.

Leta wrote:

I am trying to design a monthly invoice that will automatically insert a
monthly holiday message according to the month.


--

Dave Peterson