Excel dates to send reminders via email

Copper Contributor

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

2 Replies
my other idea is like a calendar sync, but that's still very complex
Thank you for the answer, this is quite complex and above my level of excel skill but I'll spend some time w the resources you sent and see if I can make it work.