I'm looking for a formula that gives a date range of >7th last month and less than 7th this month
e.g. >07/03/2015 and <=07/04/2015. I would always want the day range to be from the 7th of this month to the 7th of last month regardless of the day it is run.
Data type is 'Date/Time' (UK Date), can anyone help?