calculate what months an employee worked by start and end date

Hello,

I am working on a sheet that will allow a user to enter a start month (from a pre-defigned drop down list) and an end month (again from ddl).

What I need to calculate is in what months the employee worked in so I can calculate their salary cost by quarter.

It can populate other cells in order to do the calculation if needed.

So, for example if an employee started in May, and worked until December, I need to calculate that he worked 2 months in Q1, 3 months in Q2, 3 months in Q3, and 0 months in Q4.

Our fiscal year is April to March.. ;-)

I have thought of several options, but none of them have worked 100%.

Hopefully someone here can help me...

Thanks,

Welcome to the Board.

I wonder if perhaps the attached is of any interest ?

A sample file is often useful as it helps others visualise your setup and desired results.