format date in the desired format and add category color