Find number of days employees worked in a month

In this video, we discuss how to compute the number of days an employee worked for us during a month using the current month end date, joining date and leaving. And we are going to do this without using complex NestedIF function

[@roderickmose4691]

Another complex made easy video!! Thank you, Viswanathan (aka Viz), for once again sharing your knowledge and logical thinking skills for what might be for many, complex problem-solving situations.

[@suchibhargava7222]

It’s not working for same day join and leaving employee

[@kinleypenjor3305]

With this same data, could you find no of employees at the beginning of every month, no of employees left in the month and no of employees at the end of the month. Thank you

[@venkatasivakrishnaabburi3633]

What if we have rejoining and termination dates means employee who quit in the past is joined again and terminated in future date later to rejoining

[@ProfectusLearning]

You should assign new employee id for them and compute their second stint in a separate line