Excel dates to send reminders via email

My employer has asked me to make it so an excel spreadsheet that his staff uses to add in responsibilities and due dates to email him when the dates are coming up?

I have experimented with a few options, flows unfortunately couldn't help me and i didnt have any luck with VBA codes I got from google. I am aware it is a long shot but does anyone have any ideas how I can make this happen or if it is even possible?

i am somewhat new with excel but picking it up really quickly