offset to 1st day for monthly data