VBA Tips: Date and Time
Date and time
- Calculate the number of days in a month (or the last day of the month)
- Calculate the weekday (1 to 7) or display it in text format (Monday-Sunday, MO-SU)
- Date and time display formats
- Schedule the execution of a macro in X seconds or at a specific time with OnTime