A function incoprating date and a month/monetary value.
Not sure what you mean by that. Can you explain in greater detail?
--
Biff
Microsoft Excel MVP
"Christopher Leigh Stout"
wrote in message ...
Is there anyway that I can run this equation by incorporating the table
information into it?
"T. Valko" wrote:
Assuming your month names are in the range A1:A12 and are in sequential
order. B1:B12 are numeric values.
=INDEX(B1:B12,MONTH(TODAY()),0)
--
Biff
Microsoft Excel MVP
"Christopher Leigh Stout"
wrote in message
...
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?
|