Formula linked to date

[arnoldmiranda]

Hi,
I have a sheet with column with dates starting 01-Jan-2007 and I have the number of employees against each date in column B. If sheet 2 has names of employees who quit with quit dates against them, can the number of employees in sheet 1 ammend itself on the said date to reflect 1 less employee... thanks

 

[Lewiy]

I've put it all on one sheet but same principal applies to having the data on seperate sheets:

Book1
	A	B	C	D	E	F
1	Date	NoOfEmpl			Name	QuitDate
2	01/01/2007	10			Fred	03/01/2007
3	02/01/2007	10			Joe	05/01/2007
4	03/01/2007	9			Bob	08/01/2007
5	04/01/2007	9
6	05/01/2007	8
7	06/01/2007	8
8	07/01/2007	8
9	08/01/2007	7
10	09/01/2007	7
11	10/01/2007	7
Sheet3