View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Leigh Stout Christopher Leigh Stout is offline
external usenet poster
 
Posts: 9
Default A function incoprating date and a month/monetary value.

I have a column with the months Jan-Dec. In the next column I have a
corresponding monetary value. I want the monetary value for the current
month to automatically be shown in the cell and for it to update as the year
goes on. I know that I have to recalculate the workbook every day, but
still, how do I make this work?