Return date if calendar equals "eg/ig"

[steve89]

hi trying to find a formula for my leave tracker which has a calendar and is as follows:

C11:AG11 = Days in the months by the number format
B12:B23 = months in the year: Example: "january"
C12:AG23 = infractions or paid time off we enter
but i want the formula to look for "EG/IG" and if so return the date that it occured

also would like a separate formula to sat if "EG/NI" was giving then text should equal "no" and if EG/IG" was giving text should say yes.
EG stands for evaluation giving
IG stands for increase giving
NI stands for no increase giving

thanks everyone hope to get some help

=IFERROR(IF(BK27<>0,IF(BK29>=BK29,"YES","NO")&TEXT(BK29/BK27,),"NO"),"YES")
this is what i have now if the formula see "EG/IG" it reads as yes but dont know how to incorporate "EG/NI" as no.

 

[steve89]

revised i found an answer but still have a question formula works
=IF(C13="eg/ig",TODAY()) -- this returns the date this occured but i need the formula to check c13:ag23

 

[Joe4]

If you are saying that you simply want the formula to check to see if "eg/ig" exists anywhere in C13:AG13, then try this:

=IF(COUNTIF(C13:AG13,"eg/ig")>0,TODAY(),"")

 

[steve89]

thank you but that isnt working it returns todays date

 

[steve89]

has to return the date it happened

 

[Joe4]

I think we need to see some sample data and your expected output.

 

[steve89]

all the formula needs to know is if "eg/ig" occurs on the calendar that i have set which is cell C12:AG23 then tell me which date it occurred. C11:AG11 = Days in the months by the number format
B12:B23 = months in the year: Example: "january"

 

[Joe4]

So, are you saying it should find the "eg/ig" value in row 13, and then return the value from rows 11 and 12 of that SAME column?
If so, will "eg/ig" only appear once in row 13?
Can it ever appear more than once or not at all?
What should happen in those instances?

 

[steve89]

it can only appear once between cells C12:AG23 - which is the calendar. it can appear in any row between those ranges but only once. when it does appear please tell me the date that it occurred.

 

[Joe4]

when it does appear please tell me the date that it occurred.

That is what I am trying to clarify here. Please tell us exactly how to get/determine that date.
To modify the question I asked in my previous post:

So, are you saying it should find the "eg/ig" value in rows 13:23, and then return the value from rows 11 and 12 of that SAME column?

For example, if the value is found in cell Z15, and you saying that we should then return the value from Z11 and Z12 for the date?
If not, you need to explain to us that once we find the "eg/ig" value in a particular cell, how we get/determine this date?