automatic alerts 3 months before a date in MS Teams Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2106463%22%20slang%3D%22en-US%22%3Eautomatic%20alerts%203%20months%20before%20a%20date%20in%20MS%20Teams%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2106463%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20MS%20Teams%20excel%20I%20share%20with%20my%20colleagues%20we%20track%20programs%20that%20have%20a%20start%20and%20an%20end%20date.%20I%20would%20like%20to%20create%20an%20automatic%20alert%20that%20is%20triggered%20when%20the%20end%20date%20of%20a%20program%20is%20three%20months%20ahead%20of%20the%20current%20date%20(i.e.%20today).%20Ideally%2C%20this%20alert%20would%20print%20the%20content%20of%20a%20pre-defined%20cell.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EIs%20this%20possible%3F%20And%20if%20so%2C%20can%20you%20give%20me%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%20And%20sorry%20if%20this%20has%20been%20posted%20already%20somewhere%20else.%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3Eftabetao%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2106463%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Dear Everyone,

 

In the MS Teams excel I share with my colleagues we track programs that have a start and an end date. I would like to create an automatic alert that is triggered when the end date of a program is three months ahead of the current date (i.e. today). Ideally, this alert would print the content of a pre-defined cell.


Is this possible? And if so, can you give me suggestions?

 

Thanks a lot. And sorry if this has been posted already somewhere else.

Best,

ftabetao

1 Reply

@ftabetao 

I don't think so. If only to use Power Automate and check file from time to time to analyze data, but it very depends on how data is organized.