hi Bob,

Week means only weekdays i.e Monday to Friday. Sat and Sun shouldnot be
considered.
--
Thanks,
Praveen Potturi


"Bob Phillips" wrote:

How do you define a week? Is Week1 the first seven days in a month, the
days up to the first Sat/Sun? Or some other rule?

--
__________________________________
HTH

Bob

"Praveen Potturi" wrote in
message ...
Hi,

Can anyone help in doing sum of daily data with respect to weekdays. I
want
to get the sum of everydays data as week1, week2..etc. for that month

Example:-


A B C D E
1 Task Type 1-Jul 2-Jul 3-Jul 4-Jul
2 Break 0:00:00 0:00:00 0:00:00 0:00:00
3 Meeting 0:00:00 0:00:00 0:00:00 0:00:00
4 Training 0:00:00 0:00:00 0:00:00 0:00:00
5 Mentoring 0:00:00 0:00:00 0:00:00 0:00:00
6 Celebrations 0:00:00 0:00:00 0:00:00 0:00:00
7 System Dow 0:00:00 0:00:00 0:00:00 0:00:00
8 Surplus 0:00:00 0:00:00 0:00:00 0:00:00
9 Total 0:00:00 0:00:00 0:00:00 0:00:00
10
11
12
13 Week1 Week2 Week3 Week4
14 Break
15 Meeting
16 Training

In the above example I want a formula in B14, C14, D14, E14 which can do
sum
of weekdays (B2+C2+D2+E2) according to week1, week2 week3 so that i don't
have to map it everytime manually. I want excel to recongnize the data
according to the dates in B1, C1, D1.

So if dates in B1, C1 D1 are weekdays of 1st week then it should sum of
B2+C2+D2 and result should show in B14.