I am trying to find out if it is possible to create an auto-populating calendar based on the first Monday of the month, or the third Tuesday of the month, etc. The calendar I need to create is for a vehicle inspection monthly calendar. I have 6 vehicles each day of the month that need to be inspected. To keep things simple for employees, their vehicle are inspected on the same day each month (1st Monday, 2nd Monday, 3rd Thursday, etc.) I am not sure that this is even possible, but wanted to check. It would save me tons of work to be able to input that vehicle 1 is inspected every 1st Monday of each month, and have Excel automatically put that vehicle on the first Monday of each month.
Thanks!
Thanks!