Create dynamic calendar by using Excel functions

Create a fully dynamic calendar by using Excel functions.
Make the days outside the selected month grey out automatically by using conditional formatting.
How to write formula to create conditional formatting?
How to return the day of a date?
How to use LET, DATEVALUE, SEQUENCE and WRAPROWS functions in Excel?

File password 👉 AhSingCalendar

Welcome to join and feel free to raise/ask questions (if any) or share Excel tricks 🤗

#excel #functions #template