Using end of month function to calculate monthly cost

[rabbitfoot365]

Hello All, I have the following formula below. If I am using 6 30 2018 as the end date, the range the following provides is YTD (Jan1 18' to June 30 18'). Now need calendar year however so should I be using EOMONTH ? Or something else. Data!$A:$A is a column of monthly dates. B2 = 6 30 2018 how do I get the calc to look back to the last end of month to do the calc i need (lets say its just

Any feedback highly helpful. Thanks

...&ADDRESS(ROW(INDIRECT(ADDRESS(MATCH(EOMONTH(DateValue,-MONTH($B$2)+1),Data!$A:$A,0),2)))

 

[rabbitfoot365]

sorry , more clarity: in general need an automated function that will retrieve the calendar year beg and end dates for 2013, 2014, 2015, etc.