Thanks for replying and suggesting tha David.

Although, I am not even a newbie with VBA I will try to come up with at
least a pseudocode and see if I can accomplish something.


Hernan

"David" wrote:

I am guessing that each week ends on a certain day of the week ie. every
Friday and it seems that you can not do this with out designating each of
those days. Like Jan 2008, Fridays - 4, 11, 18 and 25, then you might come up
with If statements and use another column to designate a wk?.

"Rick Rothstein (MVP - VB)" wrote:

In any given month, what constitutes "Week1"? Is it always the first 7 days
of the month (Day1 though Day7) or is it the physical calendar week (Sunday
through Saturday)? If the latter, do you have any rules about where in the
week the 1st of the month must occur?

Rick


"Hernan" wrote in message
...
Hello,

I have a sheet that looks like this:


A B C D
1 Report for the month of february 08
2
3 day intakes exits dns
4 1 3 0 1
5 2 1 5 0
. .
. .
. .
totals 4 5 1

and so on to the 31st day. days 30th and 31st will have nothing for the
current report.

on the side I have:

F G H I
1 totals
2 intakes exits dns
3 week1
4 week2
5 week3
6 week4
7 week5

All of this is in a protected sheet

Is there a way to get the date from the system clock and from there
calculate the totals for intakes, exits and dns for each week. All I have
to
do at the beginning of each month is to change the name of the month in
course and enter the individual number of intakes, exits and dns.

Thank you in advanced.


Hernan