Hi SNB
Range(CDbl(CDate("15-01-2016")) & ":" & CDbl(CDate("15-07-2016")))
Ingenious.