First and last day of this month:
=dateadd("m",0,dateserial(year(Today),month(Today),1)) =dateadd("m",1,dateserial(year(Today),month(Today),0))First and last day of last month:
=dateadd("m",-1,dateserial(year(Today),month(Today),1)) =dateadd("m",0,dateserial(year(Today),month(Today),0))First and last day of next month:
=dateadd("m",1,dateserial(year(Today),month(Today),1)) =dateadd("m",2,dateserial(year(Today),month(Today),0))