Calculate within a time range with only start date and end date

L

LEG

Is there an excelfunktion (Excel 2007 version) to calculate:
How many employees are on leave of absence on a certain date, when I only
have a start date (first day in a month) in cell G2 and end date (last day in
a month) in cell H2 and the time range can vary from 0,5 to 5 years. I have
a periode of 3 years (2007 to 2009) in which I have to find out how many are
on leave on certain dates f.eks. Feb. 1 2008 and Aug. 1 2009.
Employee 1: jan 07 to jun 07 (result should be 0 on both dates)
Employee 2: jan 07 to dec 09 (result should be 1 on both dates)
Employee 3: mar 08 to mar 10 (result should be 0 on feb. 1 2008 and 1 on
Aug.1 2009)
As I have over 300 employees in the time range, it would take me a long time
to do it manually.
Any help would be appreciated.
 
L

LEG

Thanks, I used a pivot table and with some adjusting on the end date I got
what I needed.
LEG-denmark


"LEG" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
Calculate elapsed time excluding specific timeframe 10
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
identify which years are contained within a range of dates 2
Formula based on variable range 3
How to calculate difference between two date & time along with working hours and days 2
days calculation between dates 10
Help with year to date comparison 4

Top