Then you just need

=INDEX(B:B,DAY(TODAY()))

in F35

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jeremias" wrote in message
...


"Bob Phillips" escreveu:

I would have said that, assuming days in A1-A31, numbers in B1-B31, then
in
C2 input =B1, then copy down.

But you said previous would be day 15. Why?

--
HTH

Bob Phillips

Thanks. But it was not what I wanted.Suppose I have days in A1-A31 and
numbers in B1-B31. We are in the 15.th of the month, and I want a cell,
for
exemple F35, with the value of the number of clients in day 15. But if we
are
in the 16th., the same cell F35 shows the value of the clients in day 16,
and
so on.
Thanks