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]

the formula needs to know is if "eg/ig" occurs on the calendar that i have set which is cell C12:AG23 (which is only set for events or conditions that are entered) 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"

I'm seeking the date that this condition occured and the dates are set on C11:AG11 & B12:B23
U6 = date evaluation was giving

im trying to learn how to use the html maker because to help but cant find really much help on it i just submitted a thread about it.

"Employee Leave Tracker " (sheet that controls the calendar) has the following

Employee Name = B4
Start Date of event = C4
End date of event = D4
Type of leave = E4
Days = F4 which counts the amount of leave day or events per day all this information goes to the yearly calendar total for all employees which is where the previous data i provided for you is found.

 

[steve89]

am i aloud to send a workbook to you for your review because i dont know any other way

 

[Joe4]

am i aloud to send a workbook to you for your review because i dont know any other way

It wouldn't do much good from my current location, as I am unable to download/receive any files from the internet our outside locations that are not pre-approved (due to corporate security policy).

If you upload the file or images to a file (or image) sharing site and provide the links, I can look at it tonight when I am home (or perhaps someone else will take a look at it before then).

 

[steve89]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
2							Title:				cook				EMPLOYEE ID:			F19038			4/27/2012				Hire Date:
3		SELECT THE YEAR					Status:				Full Time				PAYRATE:			$15.00							Termination Date:
4		2018					Name Badges Giving:				0				ACCOUNT TYPE:			NON-UNIONIZED			YES				Evaluation Giving
5		Employee Name					Total Uniforms Giving:				0				Amount of Increase:			$1.00			3/5/2018				Increase Giving:
6		SHEMEKIA ADAMS					Total Shoes Giving:				0				Percentage Increase:			6.7%			3/5/2018				Date Evaluation Giving/Raise:
7		END DATE													Building & Payroll Code:			MILLH41 - 9YY				Yes
8		december
9
10													Employee Start Date:					Friday, April 27, 2012
11			1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
12	1	January
13	2	February	EG/IG																												NA	NA	NA
14	3	March
15	4	April																															NA
16	5	May
17	6	June																															NA
18	7	July
19	8	August
20	9	September																															NA
21	10	October
22	11	November																															NA
23	12	December
24
EMPLOYEE REPORT

 

[Joe4]

OK. I see now. This gets a little complex.
Have a look here at a very similar question and solution: https://www.mrexcel.com/forum/excel...column-header-row-header-each-occurrence.html

 

[steve89]

hey Joe first thank you again for your help really appreciate it -- also wanted to note the formula you gave originally worked just great only problem was it returned todays date instead when it occurred

=IF(COUNTIF(C12:AG23,"eg/ig")>0,TODAY(),"")

 

[steve89]

please let me know it worked well just needed the formula to check that whole section in case the event happened during a different day

 

[Joe4]

hey Joe first thank you again for your help really appreciate it -- also wanted to note the formula you gave originally worked just great only problem was it returned todays date instead when it occurred

=IF(COUNTIF(C12:AG23,"eg/ig")>0,TODAY(),"")

Yes, if you want to pull the day based on the row and column headers, you need to use the methodology proposed in the link I provided.
The formula just returns the current date (as I was not quite clear on what you wanted originally, as I did not know your data structure.

please let me know it worked well just needed the formula to check that whole section in case the event happened during a different day

I am unclear if there is a question here, or you are just making a comment?

 

[steve89]

yes it was a question sorry for the misunderstanding - i tried that method for two days now with no results

 

[Joe4]

This formula here:

[COLOR=#333333]=IF(COUNTIF(C12:AG23,"eg/ig")>0,TODAY(),"")[/COLOR]

is not going to work for you, as you do not want to pull today's date, but rather the dates from the column/row headers. So you can totally forget about that idea, it is not going to help you.

I provided a link to that thread because those formulas are beyond me, and I cannot really help you with those.

I am sorry, but there isn't much more I can do here.