Cell value

[Jeremias]

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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Jeremias]

"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

[MyVeryOwnSelf]

> ... 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()))"

[Bob Phillips]

Then you just need

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

in F35

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jeremias" <[email protected]> wrote in message
news:[email protected]...
>
>
> "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