Last day of the Month???

[Guest]

I am creating a timesheet and i have inserted the first day of the month with a combo box to a linked cell A7 then in the rest of the column i add 1 to A7 then 2 and so on for the whole month

What i need is to do a total on the last day of the week for hours worked, but i have a problem with the first week and last of the month as they are not complete weeks as the month could start on a tue or a wed etc and finish on a thur so how do i get excel to make a total per week?????
Also the position of the days change as the days of the month are automatically filled in from the first day ot the month????
HELP!!

 

[Arvi Laanemets]

Hi

Build your worksheet up on weekly basis. I.e. you set the starting date
(which will always be 1st day of week), and increment this date. You can
check the month of dates, and blanc out ones belonging to wrong month,
whenever you want. Exact setup depends on week definition in your country -
there are several different ones.

As for last day of month, p.e. with any date in A1, the last of same month
is
=DATE(Year(A1),MONTH(A1)+1,0)


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

I am creating a timesheet and i have inserted the first day of the month

with a combo box to a linked cell A7 then in the rest of the column i add 1
to A7 then 2 and so on for the whole month

What i need is to do a total on the last day of the week for hours worked,

but i have a problem with the first week and last of the month as they are
not complete weeks as the month could start on a tue or a wed etc and finish
on a thur so how do i get excel to make a total per week?????

Also the position of the days change as the days of the month are

automatically filled in from the first day ot the month????