Hi,

I'm not clear if you want to return the result for only the current date in
one cell or you want this to appear on every row. Also, I'm not sure whether
you want to return the entry in column A or really the entry in another
column.

For example, the following returns the day of the current date without
referencing any cells:

=DAY(NOW())

and the following returns the item from column B for the row of the current
day, where the entries in column are 1, 2, ...31:

=LOOKUP(DAY(NOW()),A1:A31,B1:B31)

If I wanted a column which would have the current day on the row of the
current day not just in a single cell then and still using 1, 2, 3,... in
column A

=IF(DAY(NOW())=A1,A1,"")

Now lets suppose the dates in column A are entered as legal Excel dates then
if you just want one result you would again use

=TODAY()

If you wanted it for each cell in a column (this does not need to be
adjusted for each month:

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

If you want to return the entry from another an adjacent column based on a
legal data

=LOOKUP(TODAY(),A1:A31,B1:B31)

This needs to be modified for each month sheet:

=IF(MONTH(NOW())=MONTH(A$1),LOOKUP(TODAY(),A1:A31, B1:B31),"")
This is only entered once.

In 2007 you can handle this more elegently:

=IFERROR(LOOKUP(TODAY(),A1:A31,B1:B31),"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Stacy C" wrote:

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.