PIVOT - column for each month in service

[wilkob]

I am trying to make a report based on our employee data base

I have the following fields in my list:

Company, Department, Name, Date in service, Date out of service

For my pivot I have a start and end date (example 1-1-2015 till 31-12-2015)

I am showing employees that have a date out of service >= [Start date] or Null

Now my big challenge
For each month that a person has worked I would like to see a value of 1 in my pivot

Example:

Bill : Date in service 1-1-2014
Date out of service

Cathy : Date in service 1-1-2015
Date out of service 29-4-2015

Company Department Name Jan Feb Mar Apr May June Jul Aug
ABC Sales Bill 1 1 1 1 1 1 1 1
ABC Accounting Cathy 1 1 1 1

TOTAL 2 2 2 2 1 1 1 1

Can someone help me and tell me if and how I can make a report this way?
The problem is that I only have 2 dates per employee; in service and out of service

 

[oldbrewer]

		in serv	out serv	01/01/2014	01/02/2014	01/03/2014	01/04/2014	01/05/2014	01/06/2014	01/07/2014	01/08/2014	01/09/2014	01/10/2014	01/11/2014	01/12/2014	01/01/2015	01/02/2015	01/03/2015	01/04/2015
	bill	01/01/2013	01/01/2099	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
	cathy	01/03/2014	10/12/2014				1	1	1	1	1	1	1	1	1
			formula for bill under 1/1/14
			=IF(AND($C6<E$5,$D6>E$5),1,"")

<colgroup><col><col><col span="2"><col span="3"><col span="14"></colgroup><tbody>
</tbody>

 

[wilkob]

I am sorry but I do not really understand how and where to use the formula

To make things clearer I wanted to add a sample Excel but for whatever reason I don't have permission to add attachment

What should I do to get permission?

 

[oldbrewer]

oooooopppssss this forum does not like the "<" sign

=IF(AND(b2 < a4<e$5,$d6>,b3 > a4),1,"") b2 = in serv b3 = out serv note I used a default out serv date of 2099 for employees currently in service</e$5,$d6>

<tbody>
</tbody>