Suppose I have a column with 31 cells ( the days of the month).
In those cells I want put the number (diary) of the persons coming in my shop.
But, in other column I want a cell that had the value of the number of last
day( by the way, day 15). How can I do this? Thanks

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

(remove nothere from email address if mailing direct)

"Jeremias" wrote in message
...
Suppose I have a column with 31 cells ( the days of the month).
In those cells I want put the number (diary) of the persons coming in my
shop.
But, in other column I want a cell that had the value of the number of
last
day( by the way, day 15). How can I do this? Thanks

"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

... 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 example 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

Maybe the csv file below would help.

------------------- cut here -------------------
1,55
2,86
3,48
4,56
5,63
6,63
7,67
8,23
9,87
10,66
11,74
12,6
13,55
14,5
15,29
16,46
17,78
18,98
19,51
20,26
21,31
22,39
23,89
24,94
25,78
26,57
27,32
28,11
29,58
30,75
31,78



,,,,,"=INDIRECT(""B""&DAY(TODAY()))"

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