Hey guys and happy new year,

i am setting up a spread sheet as a kind of sign in/out sheets i.e.


(colA) (colB)
mon | mon
------|-------
am | pm
------|------
in | out
------|-------
06:00 | 18:00

the sheet will look somethin like the above but carrying on for the entire
week, i will hace the sheet count all the instances of certain things i.e.
sickness, holidays, etc. What i would like to know is there a way of getting
excel to perform an operation depending on the day, so only count columns A
and B if today is monday?

any assistance would be very much apprieciated.

cheers

The Noob

It depends on the oranization of your data. Here is a sample of how to
calculate based on day of the week. Say In B1 thru H10 we have:

mon tue wed thu fri sat sun
10 7 6 1 6 0 1
7 0 10 8 0 10 0
10 1 3 4 2 6 1
6 9 2 6 1 6 7
10 8 9 10 2 6 4
5 10 8 3 6 2 5
4 1 0 2 6 9 7
10 8 1 6 5 4 10
7 4 9 4 10 1 6

We want to get the sum of the column for today (sat). In A1 enter:

=CHAR(WEEKDAY(TODAY())+64)
This displays G
which is correct column for today (sat)

In B1 enter:
=SUM(INDIRECT(A1 & ":" & A1))
the displays 44
which the the sum of today's column!

--
Gary''s Student - gsnu200825


"Noob McKnownowt" wrote:

> Hey guys and happy new year,
>
> i am setting up a spread sheet as a kind of sign in/out sheets i.e.
>
>
> (colA) (colB)
> mon | mon
> ------|-------
> am | pm
> ------|------
> in | out
> ------|-------
> 06:00 | 18:00
>
> the sheet will look somethin like the above but carrying on for the entire
> week, i will hace the sheet count all the instances of certain things i.e.
> sickness, holidays, etc. What i would like to know is there a way of getting
> excel to perform an operation depending on the day, so only count columns A
> and B if today is monday?
>
> any assistance would be very much apprieciated.
>
> cheers
>
> The Noob