Non excel expert! Trying to create formula for occurrences within previous 3 months

[Debbieannbee]

I have a spreadsheet which details when a member of staff has received a warning. I want to be able to see when they reach a total of 3 warnings within a period of 3 months. Am trying the If function with two separate options, but struggling to achieve the right result, particularly in relation to the date range... can anyone help???

[Richard Buttrey]

Hi,

You probably need to be using the COUNTIF() function, but we'll need to see the workbook to comment with more certainty.

[easyexcelanswers]

I have some basic if function guide lines
http://easyexcelanswers.com/func_for...#IF Statements

If you could provide more detail, I could maybe give you a better answer

[Debbieannbee]

Essentially the sheet is as follows: (I can't post images from work)

Name Instance Department 1st Date Employee last Date Action Manager
************ 1st ************ 08/02/14 0208/476 17/02/14 Informal ************
************ 1st ************ 08/02/14 1250/476 18/02/14 Informal ************
************ 1st ************ 08/02/14 0838/476 17/02/14 Informal ************
************ 1st ************ 10/02/14 1450/481 18/02/14 Informal ************
************ 1st ************ 10/02/14 1203/481 18/02/14 informal ************
************ 1st ************ 11/02/14 1402/482 17/02/14 Informal ************
************ 1st ************ 13/02/14 1320/484 18/02/14 Informal ************
************ 1st ************ 13/02/14 822/484 18/02/14 Informal ************
************ 1st ************ 14/02/14 0838/485 18/02/14 Informal ************
************ 1st ************ 14/02/14 0320/485 28/02/14 Informal ************
************ 2nd ************ 16/02/14 1316/487 28/02/14 Informal ************
************ 2nd ************ 16/02/14 1331/487 18/02/14 Informal ************
************ 1st ************ 18/02/14 1251/494 21/02/14 Informal ************
************ 2nd ************ 22/02/14 0821/496 27/02/14 File Note ************

I need to be able to see when an employee reaches his/her 3rd instance, but also to know that this has been reached within a three month period (between the 1st date and the last date). I hope I am explaining myself properly!

[Debbieannbee]

=IF(B24:B46="3rd","Assess","Ignore")

I had managed to use this to recognised that the 3rd instance had been reached, however, couldn't figure out how to add a function which would also encompass the three month period.

[easyexcelanswers]

=IF(B1:B13="3rd",IF((MONTH(D1)-MONTH(C1)>=3),"Assess","Ignore"), "ignore")
date_ignore.xlsx

[Debbieannbee]

Perfect! Thank you so much!