Hello
I have 2 toggle buttons 1) I want to show ALL values for the minimum month and
2) I want to show all values for the next month
However, my code at the moment is only showing the minimum date in that first month, I.e. If April 2013 is the minimum month, then my code is returning all data for 02/04/2013 however, I want my code to bring back all values for 02/04/2013 - 04/2013
Here is my current code
Current Month = Min(breach_test)
Next Month = =AddMonths(Min(breach_test)+1,+1)
I have 3 months in this format 04-2013, 05-2013, 06-2013 and the information behind this format is an actual date
(hence why I am probably only returning the miinimum date, not the minimum month)
Can anyone help me return all the dates in the minimum month?
Thanks
Helen