What Week İs Finding Function Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Dim tarih As Date, hafta As Integer tarih = Date hafta = DatePart("ww", tarih, vbMonday, vbFirstJan1) MsgBox "Bugün: " & Date & " --> Yılın " & hafta & ". Haftası" Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 What week is finding function 2 excel operators hk 3 selection of filled fields and finding the last filled cell 4 Function codes that find out what week 5 Enter date in A1 to find out what week is in B1 6 Collects cells that are red between a1: d20 7 a .bat file from a floppy disk 8 api that finds which key is pressed 9 Adding values of cells of a particular color, for example, what is the sum of cells of yellow color? 10 Fetch sheet / page name with function 11 Adds cells with red background color between cells A1: d20 12 It takes data from "listbox a" and then writes "textbox b" 13 Export selected cells to text file 14 Multiplies what is written in inputboxes 15 calculator on / off 16 collects selected fields in status bar 17 used xl turkish english ..... or what? 18 The data you receive in combobox is changed to big week 19 Finding the Number of Each Item in the List Using the VBA and Pivot Table 20 adding two lines and removing total