I found this function that calculates the week of a month and it works great on a spreadsheet but I need to work on a userform.
Function WeekOfMonth(dDate1 As Date) As String Dim dDate2 As String
Dim wWeek As Integer
'dDate2 is changed to date from String
dDate2 =...