excel display month if in range if true display email

[eric86vabeach]

[TABLE="width: 500"]
<tbody>[TR]
[TD]date
[/TD]
[TD]email
[/TD]
[TD]jan
[/TD]
[TD]feb
[/TD]
[TD]mar
[/TD]
[TD]may
[/TD]
[TD]jun
[/TD]
[TD]jul
[/TD]
[TD]aug
[/TD]
[TD]sep
[/TD]
[TD]oct
[/TD]
[TD]nov
[/TD]
[TD]dec
[/TD]
[/TR]
[TR]
[TD]1/1
[/TD]
[TD]bob@gmail
[/TD]
[TD]bob@gamail
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/2
[/TD]
[TD]eric@gmail
[/TD]
[TD][/TD]
[TD]eric@gmil
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5/5/2014
[/TD]
[TD]helpme@excel.com
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]helpme@excel.com
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



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