Employee Still Active

[Sameer9585]

Hi,

I have a data set where it contains ID,Date of Resignation and Date of Termination now I require that how many employees are active till the year and month selected in filters.

I require the count of people count who are going to leave the company next month also it should be included in the count.

I provide the data set in it Sheet 3 is the one.Please look into it.

Thanks in advance,

[Anil_Babu_Samineni]

Perhaps this?

=Count(If(Resigntation<=Termination, ID))++Count({<Num_Month={"=Num(Month(Today()))"}>} ID)

Where as Num_Month as follows in script

Num(Month([Date of Termination])) as Num_Month

[Sameer9585]

Hi Anil,

Count is correct but there is another problem that I need to create a cumulative substraction from the count(ID) and it should decrease montly.