Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.