### How to use Weekday function in VBA?

In VBA (Visual Basic for Applications), the Weekday function is used to get a numeric value representing the day of the week for a provided date. The value returned by the function follows the VBA vbDayOfWeek enumeration, where by default Sunday is 1, Monday is 2, and so on through Saturday, which is 7. However, you can specify a different starting day for the week by using the second optional argument