Need help with IF function

[Cheslop84]

In column A I have dates from 1/1/16 to 31/12/16

In cell d2 I have employee start date. In cell d4 I have leaving date

I need column to show employment status for everyday using the start date cell and leaving date cell as point of reference.

If start date is after 1/1/16 I want cells in column to say NA until we reach their start date in column a. Once employment starts I want cells in column b to say CURRENT from the date specified in the start date box. Then I want the cell to say LEAVER once a date has been inputted in to leaving date cell. (Leaving date cell will be blank until I input a leaving as and when it is relevent)

I need column b to show visible timeline of employment status, I.e. the cells in column b for which the dates in column a fall inside start date and leave date cells will say CURRENT and those outside these dates will either say NA or LEAVER, whichever is applicable.

Any ideas?

 

[Cheslop84]

3rd line down That should say I need column B to show...

 

[Cheslop84]

5th line down should say...I want cells in column B to say NA...

 

[FormR]

Hi, welcome to the forum

Here is one option you could try:

Excel 2013
	A	B	C	D	E
1	Date	Status		Start	Leave
2	01/01/2016	NA		10/01/2016	18/01/2016
3	02/01/2016	NA
4	03/01/2016	NA
5	04/01/2016	NA
6	05/01/2016	NA
7	06/01/2016	NA
8	07/01/2016	NA
9	08/01/2016	NA
10	09/01/2016	NA
11	10/01/2016	Current
12	11/01/2016	Current
13	12/01/2016	Current
14	13/01/2016	Current
15	14/01/2016	Current
16	15/01/2016	Current
17	16/01/2016	Current
18	17/01/2016	Current
19	18/01/2016	Current
20	19/01/2016	Leave
21	20/01/2016	Leave
22	21/01/2016	Leave
23	22/01/2016	Leave
24	23/01/2016	Leave
25	24/01/2016	Leave
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2<$D$2,"NA",IF(AND(A2>$E$2,$E$2<>""),"Leave","Current"))