This content has been marked as final. Show 5 replies
I want to create a text box that says: Data Processed From 1/1 of the year prior to the selected year through the max report date of the year prior to selected year. Ex. "Data Processed From 1/1/2016 - 5/31/2016" when 2017 is selected.
I have the first part but am having trouble with the second.
=If(Only(Year),'Data Processed From 1/1/' & (Only(Year)-1))
It doesn't have to be all in one formula, but that would be ideal