Hi

I have been having issues with a training plan and was given a formula to
calc the days the course used in each month but this included weekends, and
noone has been able to help to only show workdays so not sure how you will
only do 4 days each week.

In brief my sheet you put in a start date (m7) and an end date(n7), Q5 in a
mm-yy field to match a month. Note Q5 was Jan-10 and the columns went to AB5
(dec-10) so with the formula copied across all columns if a course covered 1
or more months then this would say how many days in each month.

=SUMPRODUCT(--ISNUMBER(MATCH(ROW(INDIRECT($M7&":"&$N7)),ROW(INDI RECT(DATE(YEAR(Q$5),MONTH(Q$5),0)+1&":"&Q$5)),0)))


Not sure if this will help in any way but if you do crack it please let me
know, email me if you could. .

Cheers and good luck

UKMAN

"froggygremblin" wrote:

I want to calculate the number of days worked on a project in a rolling 4
month calendar. Working Days are Mon-Thu. My sheet looks like this:

Jobname TotalDays StartDate EndDate DaysMo1 DaysMo2 DaysMo3 DaysMo4
Foo 3 3-22-10 3-25-10 3 0
0 0
Goo 25 4-2-10 5-17-10 0 17 8
0

I have used Workday to calculate my enddate but I'm having difficulty
calculating the proper month bins to put the days in. Since the calendar
rolls forward ewach month I need to consider that a job started before Mo1 or
in Mo1 or in Mo2 or in Mo4 or it'sw beyond the planning horizon. Anyone
solved this before?

Thanks for any guidence