Need vba help on popup calendar and change status on another column

Hi experts

I have emp tracker, which is accessable by teams, i want enter proper date format in Joining date and Lastworking date column

depend upon date enter column N & P Status column value get change

for e.g
if joining date popup calender i pick one date, in status get change as active
if LWD date popup calender, i pick future date, in status get change as Notice period
once date crossed status get change as Resigned

please find the attachment calender in userform,need pop-up in N an P column if place cursor in cell


thanks and regards

Pls find the attachment, i want work for 2 column N and P, and O Column get change depend upon,

Hi

i need help assign code on task, please help on this

Yes on Part3 Code