excel display month if in range if true display email

[eric86vabeach]

date

email

jan

feb

mar

may

jun

jul

aug

sep

oct

nov

dec

1/1

bob@gmail

bob@gamail

2/2

eric@gmail

eric@gmil

5/5/2014

helpme@excel.com

helpme@excel.com

<tbody>
</tbody>

so what I'm working on is a sheet some what looks like this and Im looking for a code that if the date is in range of month then shows email in that month

can this be done?


thanks
eric

 

[FormR]

Something like this maybe:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	date	email	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	01 Jan 2014	a.com	a.com
3	02 Feb 2014	b.com		b.com
4	05 May 2014	c.com					c.com
5	01 Dec 2014	d.com												d.com
Sheet1

 

[eric86vabeach]

thanks IT WORKS THANKS FOR YOUR TIME AND HELP