Is there a way to have excel send a reminder email for certain tasks on a certain date?

Dear Jessica,

The built-in Excel option has no such features.

However, you can use Power Automate to do that.

You can just create a scheduled flow like the following. The flow filtered all tasks whose due date is two weeks after today and send an email notification to you.

Excel sheet:

.

Flow Details:

.

Compose: add(div(sub(ticks(addDays(formatdatetime(utcNow(),'yyyy-MM-dd'),14)),ticks('1900-01-01T00:00:00Z')),864000000000),1)

Filter Array: int(item()?['Due Date']) is equal to int(outputs('Compose'))

Compose2: items('Apply_to_each')?['Task']

Compose3: items('Apply_to_each')?['Due Date']

Value of Append to array variable:

{

"Task":"@{outputs('Compose_2')}",

"Due Date":"@{addDays('1899-12-30',int(outputs('Compose_3')), 'dd-MMM-yyyy')}"

}

Compose4: replace(body('Create_HTML_table'),'<table>','<table border="1">')

Result:

.

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Dear Jessica,

You can click on + Create>Scheduled flow to start the scheduled flow. The flow will be started in the new design mode. You can switch to the classic design mode as you like. The example flow above is designed with the classic design mode.

.

For more detailed information, please refer to the following articles.

Run flows on a schedule in Power Automate - Power Automate | Microsoft Learn

Understand the cloud flows designer - Power Automate | Microsoft Learn

Welcome to share any updates at your convenience if you need further help on this issue.

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Thank you for this.

I just need some guidance on how to start the flow.

I logged onto power automate and I can't find any option that says "recurrence."

Which option in the snippet below do I choose to start the flow?

like excel to send me

I have no idea of this feature.

The canledar app in smart phone does have reminder.