Counting totals within month period

[shabbaranks]

Hi all,



Im struggling to get my head around how to tally the number of employees within a month by month period (its too early and I haven't had enough coffee) calculating leavers also.

I've attached my current workings which almost works and Im just wondering if I am trying to make it too complicated. I want to be able to show the total number of employees within each month indicating what the count is for that month and going forward - please help

[Pecoflyer]

Why not use a simple Pivot Table?

[shabbaranks]

Originally Posted by Pecoflyer

Why not use a simple Pivot Table?

haha you say simple pivot table - I'm useless at Excel, looked up pivot table and gave up

Any help would be appreciated.

[ArviLaanemets]

I din't understand exactly, what you need to calculate, so on sheet Report are some different choices available.

I started with sheet EmplCalendary, but at end was it not needed. I didn't delete the sheet, and some Dynamic Ranges I created - maybe you find some use for them.

[shabbaranks]

Originally Posted by ArviLaanemets

I din't understand exactly, what you need to calculate, so on sheet Report are some different choices available.

I started with sheet EmplCalendary, but at end was it not needed. I didn't delete the sheet, and some Dynamic Ranges I created - maybe you find some use for them.

Thanks - looks exactly what I need. I've just created another page to create my own pivot using your methods (as I want to try and understand how it works).

Again it made me laugh when you say a simple pivot table as your example wasn't simple

Thanks again

[Pecoflyer]

Well, if the free help you get here is laughable, you should consider other options...