►Unit topics:
Automatic schedule design | Learn these functions, so that your schedule can be used for thousands of years~

►Description:
In the Excel software, the schedule is a form that many industries will need to design, but the date is often changed every month, and everyone often needs to spend another time to sort out the date. Today, this video will show you Redesign the schedule from the beginning to the end. You only need to do it once, and it will be your tenthousandyear schedule. Today's functions will be used a lot, so you must read it carefully~

►Version used for this video recording: Microsoft Excel 365
►Sample file download: https://1drv.ms/u/s!Aqp4JwPG9GlVgcNhU...
► Functions used (if, iferror, date, weekday, match)