Worksheet calculations for 1st, 2nd, 3rd... Mon-Sun of a month?

A

Android

Hi

I have a worksheet where the date for each month is populated when you
select a year and month. I need to do averages for each week. If the 1st
week starts with Thu (for example) the average for that week would be from
that Thu to the next Sun.

Ie., is here a way to select for:
- 1st day of month to 1st Sunday of month? &
- Nth Monday of month to Nth Sunday of month?

Is there a way to select for one week at a time?

The following represents a sample of the sheet.

Year: 2004
Averages for
Thu Fri ...... Sun Apr
Apr 1 Apr 2 Apr 4
Apr 1-4 Apr 5-11 Apr 12-18 ....26-30
------ ------ .... ---------
...... -------- -------- ---------- --------
Time for Activity X
Resource for X
:
:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating occupational sick pay entitlement 0
Unhide column difficulty 3
How do i repeat dates monthly over the year 2
Finding 3rd (or 2nd) Sunday in a given year/month 5
CrossTab report "super" columns 5
SUMPRODUCT formula help?? 1
Still trying to average 4 worksheets and having formula problems 3
Number of hrs worked in a week, based on dates in a different column 1

Top