Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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