[{"_id":"63904934763bb94e677e6692","date":"Wed Dec 07 2022 05:00:00 GMT+0500 (Pakistan Standard Time)","check_in":"2022-12-07T10:07:00.000Z","check_in_remarks":"","late_time":"00:07:00","status":"present","user":"testUser","createdAt":"2022-12-07T08:05:08.992Z","updatedAt":"2022-12-07T12:03:53.457Z","__v":0,"check_out":"2022-12-07T18:07:00.000Z","check_out_remarks":"","early_off":"00:53:00","over_time":"","totalHours":28800},{"_id":"63904934763bb94e677e6693","date":"Wed Dec 07 2022 05:00:00 GMT+0500 (Pakistan Standard Time)","check_in":"2022-12-08T10:07:00.000Z","check_in_remarks":"","late_time":"00:07:00","status":"present","user":"testUser","createdAt":"2022-12-07T08:05:08.992Z","updatedAt":"2022-12-07T12:03:53.457Z","__v":0,"check_out":"2022-12-07T18:07:00.000Z","check_out_remarks":"","early_off":"00:53:00","over_time":"","totalHours":28800},{"_id":"63904934763bb94e677e6694","date":"Wed Dec 07 2022 05:00:00 GMT+0500 (Pakistan Standard Time)","check_in":"2022-12-01T10:07:00.000Z","check_in_remarks":"","late_time":"00:07:00","status":"present","user":"testUser","createdAt":"2022-12-01T08:05:08.992Z","updatedAt":"2022-12-01T12:03:53.457Z","__v":0,"check_out":"2022-12-07T18:07:00.000Z","check_out_remarks":"","early_off":"00:53:00","over_time":"","totalHours":28800}]

db.collection.aggregate([{$match:{user:"testUser",check_in:{$regex:"^2022-12"}}},{"$project":{user:1,"date":{"$toInt":{"$substrCP":["$check_in",8,2]}},mon:{"$toInt":{"$substrCP":["$check_in",5,2]}},y:{"$toInt":{"$substrCP":["$check_in",0,4]}}}},{$group:{_id:"$user",dates:{$addToSet:{day:"$date"}},month1:{"$last":"$mon"},year1:{"$last":"$y"}}},{$project:{dates:{$map:{input:{$range:[1,{$sum:[{"$toInt":{"$substr":[{$subtract:[{$dateFromParts:{"year":"$year1","month":{$add:["$month1",1]}}},86400000]},8,2]}},1]}]},as:"day",in:{$let:{vars:{dayIndex:{"$indexOfArray":["$dates.day","$$day"]}},in:{$cond:{if:{$ne:["$$dayIndex",-1]},then:{day:"$$day",presence:"Present"},else:{day:"$$day",presence:"Abs"}}}}}}}}}])