• For start date to always get Previous Month Use

    =Datetime.Today.AddDays(-Day(Datetime.Today)+1).AddMonths(-1)

    For End Date to get Last Date of Previous Month

    =Datetime.Today.AddDays(-Day(Datetime.Today))