Say you have *legal* XL recognized dates in A1 to A31 (7/1/2009 to
7/31/2009).

You have values in B1 to B31.

This formula will return the value in Column B corresponding to today's
date:

=INDEX(B1:B31,MATCH(TODAY(),A1:A31,0))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Stacy C" <Stacy wrote in message
...
Good morning,

I am setting up a spreadsheet wherein I have a row for each day of a month,
with numeric values. I need to be able to setup a formula similar to:

IF(DAY(TODAY())=1,A1,"")

So that another field will automatically reference the correct cell each day
(each day has it's own cell). The problem I have is that I cannot embed
enough "IF" statements to encompass all 31 days within a month. I am not
experienced with Macros/VBA at all, but if there is an easier method to do
this using those tools, I am open.

Any advice is appreciated. Thank you in advance.