software

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)

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


quot;Bob Phillipsquot; escreveu:

gt; I would have said that, assuming days in A1-A31, numbers in B1-B31, then in
gt; C2 input =B1, then copy down.
gt;
gt; But you said previous would be day 15. Why?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
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

gt; ... Suppose I have days in A1-A31 and
gt; numbers in B1-B31. We are in the 15.th of the month, and I want a
gt; cell, for example F35, with the value of the number of clients in day
gt; 15. But if we are in the 16th., the same cell F35 shows the value of
gt; the clients in day 16, and so on.
gt; 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
,,,,,quot;=INDIRECT(quot;quot;Bquot;quot;amp;DAY(TODAY()))quot;

Then you just need

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

in F35

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Jeremiasquot; gt; wrote in message
...
gt;
gt;
gt; quot;Bob Phillipsquot; escreveu:
gt;
gt; gt; I would have said that, assuming days in A1-A31, numbers in B1-B31, then
in
gt; gt; C2 input =B1, then copy down.
gt; gt;
gt; gt; But you said previous would be day 15. Why?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; Thanks. But it was not what I wanted.Suppose I have days in A1-A31 and
gt; numbers in B1-B31. We are in the 15.th of the month, and I want a cell,
for
gt; exemple F35, with the value of the number of clients in day 15. But if we
are
gt; in the 16th., the same cell F35 shows the value of the clients in day 16,
and
gt; so on.
gt; Thanks