Select cell A2, type =DATEDIF (A1,TODAY (),"y"), and press ENTER to see the person's current age in cell A2. ). Search for the Function you want to use, and select go. January 1, 1900 is 1, January 2, 1900 is 2, and so on. We would like to show you a description here but the site won’t allow us. Cara Menghitung Masa Kerja di Excel. 22 June 2000. For instance, let's say David's DOB is 10/01/1990. The Excel DAYS360 function returns the number of days between two dates based on a 360-day year, where all months are assumed to have 30 days. Vypočíta počet dní, mesiacov alebo rokov medzi dvomi dátumami. What it Returns. Rumus DATEDIF yang pertama ini hanya akan menghitung selisih tahunnya saja, sisa bulan dan hari akan diabaikan. ฟังก์ชัน DATEDIF มีขั้นตอนการใช้งานดังนี้ครับ. DATEDIF. For example, you might use DateDiff to calculate the number of days between two dates, or the number of weeks between today and the end of the year. Introduction to data calculationsWorking with date time format excel 2013 beginners tutorial. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. . 10 seconds are (almost) exactly that fraction of 24 hours that you get as the answer. You can use the following formula to calculate the person’s age: = DATEDIF (A1, A2, "Y") This will give you the person’s age in years. . In a few recent posts, we have explored different ways to calculate dates and times in Excel and learned a variety. Cara Menghitung Umur di Excel Menggunakan Rumus DATEDIF. I have a DATEDIF value, and on which the IF condition is not working. com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. Cell A2 is the Start date reference. Let’s take a look at the formulas: The first formula is just a simple subtraction of the two dates, A3 – A2. Here is the formula I used: =DATEDIF(A2,TODAY(),"Y") where A2 was the cell with the birth date. In the Save As dialog, select ‘Publish Sheet’ and ‘Add Interactivity’. "&DATEDIF (D3,TODAY (),"YM")&". DATA. The formula should produce an integer and the cell format should be Custom [=1]0 "month";0 "months". datedif. This function returns the number of whole days, months or years between Start date and End date. Working days exclude weekends and any dates identified in holidays. The steps to calculate DATEDIF in Excel are as follows: Step 1: Select an empty cell to display the output. Select the cell where you want to type your formula, and add the following: =DATEDIF (“01/01/2018”,”24/05/18. First, you can switch the. See attached example. 1. 4 Calculate Number of Days Ignoring Years. I use Excel 2013 and scandinavian dates and cannot get DATEDIF-function to work. In reply to V_Agarwal's post on March 15, 2017. DATEDIF stopped being documented awhile ago, but it's still a valid function. Click the cell containing the date of birth. 4 Calculate Number of Days Ignoring Years. View ProfileDATEDIF(start_date, end_date, unit) start_date - The start date to consider in the calculation. Just make sure these dates in double-quotes is in an accepted date format in Excel. Tải và cài đặt Office 2013 Sử dụng bản thấp hơn, các bạn có thể tải và cài đặt Office 2007. Calculate Difference Between Two Dates Using DATEDIF Function. W. Calculates the number of days, months, or years between two dates. First put a start date in a cell, and an end date in another. But if you know the syntax, which I’ll share with you in a moment, you can use it for a range of applications. בתרחישים מסוימים, הפונקציה DATEDIF עשויה לחשב תוצאות שגויות. Silakan lihat bagian masalah umum di artikel ini untuk detail selengkapnya. Its syntax includes three arguments: start_date, end_date, and unit. التسميات : DATEDIF تمكنك من تحديد عدد الأيام و الشهور و السنوات المتبقية على موعدك, Excel ابـدأ نـت دليلك في تعلم استعمال الكمبيوتر والأنترنت إذا أعجبك الموضوع، شاركه مع أصدقائك أو قم بتقييمه. 1 Determine Number of Days. Whether it would be the number of. Excel DATEDIF funkció. 1 Determine Number of Days. INTL. The Difference Between DATEDIF and YEAR/MONTH Formulas. Introduction to DATEDIF Function. Right-click on the cell and click Format Cells (or press CTRL+1) and make sure the cell follows the Text format. V určitých situáciách môže funkcia DATEDIF vypočítať nesprávne výsledky. (ISO/IEC 26300:2-2015)Press Enter key. In the Formulas Helper dialog, please select Convert days to year month day. Here, I selected cell E5. Once done, you will have the number of months between the two dates in column D. 「DATEDIF（デイトディフ）」という関数名は、「日付」の「DATE」と「差分」の「DIFFERENCE」を組み合わせたものであろうと思われます。. จะคำนวนหาอายุใน Excel ใช้ฟังชั่นอะไรอะครับ ?? Microsoft Excel Microsoft Office. Conclusion: Sharon's birthday is in 32 days. Likewise, use the interval value y to calculate the number of years between two dates. Please pay attention that compared to DATEDIF, a DAYS formula requires the arguments in the reverse order: You can always ask an expert in the See moreUse the DATEDIF function when you want to calculate the difference between two dates. =DATEDIF(C5,D5,"YM") Rumus diatas digunakan untuk menghitung jumlah bulan yang tersisa setelah jumlah tahun dihitung selama periode masa kontrak berlangsung. Na planilha do Excel, se você quiser calcular o número de anos, meses, dias ou semanas entre duas datas, o DATEDIF função no Excel pode ajudá-lo. I am attempting to use the DATEDIF function within an IF statement to tell me the amount of days since I have. 오늘은 엑셀 함수 datedif 함수를 사용하는 방법에 대해 알아볼게요 근무년수, 근무월수, 근무일수 등과 같은 날짜를 계산할 때 datedif 함수를 사용할 수 있는데요 기본적으로 datedif 함수를 사용할 때에는 함수 인수로 시작일과 종료일과 함께DATEDIF - Hàm đếm số ngày, tháng, năm trong Excel 2007 2010 2013 2003. Enter the date of birth into cell A2. Kamu bisa menganggap DATEDIF sebagai rumus “tersembunyi” di excel karena kamu tidak akan mendapatkan saran penulisan dari excel ketika kamu mengetikkannya. Jan 8, 2016 at 9:29. Contoh yang kedua kita akan menghitung selisih tanggal dengan rumus DATEDIF dan. Then the 1 represents the first day of that month. 1. The Microsoft Excel DATEDIFF function returns the difference between two date values, based on the interval specified. Excel treats months as values (1 through 12), which makes it easy to subtract an earlier date from another date as long as both dates fall in the same year. This tutorial explains the syntax and uses of the Excel YEAR function and provides formula examples to extract year from date, convert date to month and year, calculate age from the date of birth and determine leap years. in 13. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Una forma muy simple para trabajar con fechas. . Returns the serial number of a particular date. Use the DATEDIF function to find the number of years between your dates: Open a spreadsheet and navigate to the two specific dates. Calculate how many days are in the last month of the period. A difference in complete months, Ignoring days and years. DATEDIF(C5,D5,”y”) —-> Here, the DATEDIF function will return the number of years between the two given dates. แนวทางการปรับสูตร DATEDIF ให้ทำงานดั่ง. Although my friend SirJB7 will (rightly) point out that ti does has some flaws when doing certain calculations. 2) Countif to compare that number to the lower threshold and upper threshold day counts to select the correct multiplier. Step 1: Open Excel 2013. Now you will see a different color for the weekends. The DATEDIF function does exactly what the name suggests. DATEDIF 함수는 특정 시나리오에서 잘못된 결과를 계산할 수 있습니다. But if you know the syntax, which I’ll share with you in a moment, you can use it for a range of applications. end. We'll carry forward the last formula where we added text to the full weeks that passed between the dates in C3 and D3. 2. It’s syntax is: =DATEDIF(start_date, end_date, unit) start_date – The start date in Excel serial number format. It seems I need another IF statement to check for blanks then use. 1. AGORA (NOW)DATEDIF function (microsoft. Re: Datedif not working in Excel 2013. Using NETWORKDAYS Function to Calculate Working Days in Excel Excluding Weekends and Holidays. Steps: Firstly, select the cell where you want the age. Follow the steps with me and enhance your Excel skills. Output: 7; DATEDIF(C5,D5,”ym”) —-> Here, the DATEDIF function will return the number of months between the two given dates ignoring the days and years. For example, items on the Site Actions menu in SharePoint are now on the Settings menu. In addition, you can also use the DAYS function. Q2. For some reason, this hint box doesn't appear when using DATEDIF (). Click the cell containing. This is a great function if you work. In the VBA Editor, you can type “DateDiff (” to see the syntax for the DateDiff Function: Interval: Time unit (Days, Months, Years, etc. You may not post new threads; You may not post replies; You may not post attachments; You may not edit your postsAvailability Excel Versions Availability Category Excel 2016 Yes Excel 2013 Yes Hidden Excel 2010 Yes Hidden Excel 2007 Yes Hidden Excel 2003 Yes Hidden Reference language Language Designation English DATEDIF Translations Language Designation Danish DATO. DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. TheDate = InputBox ("Enter a date") Msg = "Days from today: " & DateDiff ("d", Now, TheDate) MsgBox Msg. Cách thêm hàm DATEDIF vào Excel như sau: Bước 1: Bạn mở file Excel ra và chọn vào mục “File” nằm phía trên, góc trái thanh công cụ. Khi sử dụng Excel trong công việc, bạn sẽ thường gặp một vài bài toán yêu cầu bạn phải xác định thời gian giữa 2 khoảng thời điểm khác nhau. 1. Must be a reference to a cell containing a DATE , a function returning a DATE type, or a number. Step 3: Now write. DATEDIF is an Excel function tailored for this exact task. Google Sheets will now tell you that the spacecraft has traveled for 569 days. How to use DATEDIF in Excel. Quote from excel. Excel 2013: Get the formula in a cell : reference: GETPIVOTDATA: Excel 2003: Retrieve data from a pivot table in a formulaPreviously in Excel 2010 and Excel 2013, MS used to provide a date function named DATEDIF. But if I change the DATEDIF value to numeric mannually then the IF function is working. Suppose the person’s date of birth is in cell A1 and the current date is in cell A2. You can use the DateDiff function to determine how many specified time intervals exist between two dates. You can format the value returned by TODAY with a date number format. If you need to count the number of dates between two dates in Excel, you don't need to use DATEDIF and other Excel date manipulation functions. This is a great function if you work. The third argument “YM” specifies the information to be extracted i. A good example would be calculating the age. 2 Comments [Author: Jan Podlesak Category: Other] DATEDIF is very useful for counting the number of whole calendar years, months and days between two dates. DATEDIF เป็นฟังก์ชั่นที่ใช้หา ระยะห่าง ระหว่าง วัน 2 วัน. Formula for this unit is =DATEDIF (start_date, end_date,”ym”) So the given example shows the answer 6, as the difference between month # 7 and month # 1. We often compare two dates and calculate the difference between them in terms of days, weeks, months and years. months. Step 2: First, we must enter the DATEDIF formula in the first row and use “YD” as a unit in a formula. Steps: Firstly, choose the D5 cell and write the following formula down, =DATEDIF (B5,C5,"ym") Then, press the Enter button. Now it’s time to combine all these to create an accurate age. برای این قسمت، از برگه “” DATEDIF در کتاب تمرین نمونه استفاده کنید. For example, if you start a project on 01 Jan and it ends on 31 Jan, the DATEDIF function. In the Date & Time Helper dialog box, do the following operations:. I am unable to use conditional formatting as Excel says that relative formatting is not permitted within conditional formatting. I searched Excel help and function reference, and MS knowledgebase. Date2: A scalar datetime value. Moi aussi (15) Posez votre question. The datepart value cannot be specified in a variable, nor as a quoted string like 'month'. DATEDIF(B3,C3,"y") returns the number of years between two dates. โครงสร้างของฟังก์ชั่นคือ. Introduction to DATEDIF Function. To round up to the nearest month, see below. The DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates. Be sure to replace the “XX” in the formula. First, confirm that =ISNUMBER(--C3) returns TRUE. W. One little known way is to use the secret Excel DATEDIF function. Như bạn đã thấy ở trên, hàm DATEDIF tính toán chênh lệch giữa ngày bắt đầu và ngày kết thúc. The users of Excel 2013 and Excel 2016 have one more amazingly simple way to calculate days between two dates - the DAYS function. Hasil rumus DATEDIF dalam contoh yang pertama ini adalah 1 dan angka tersebut jika dihitung secara manual didapatkan dari : 2023 – 2022 = 1. I suspect it's secret because. I'll try to explain why I need this - we have deadlines, different tasks have different amount of days to complete them. Answer: If you are getting a negative answer, you have two ways to return a positive value. An example of getting month difference between two dates. I would write the unit into the cell format, not the formula. עיין בסעיף 'בעיות מוכרות' במאמר זה לקבלת פרטים נוספים. =DATEDIF(A3, B3, "ym") //difference in months, year component is ignored. Basis - use basis 1 that tells Excel to divide the actual number of days per month by the actual number of days per year. 461 4 4 silver badges 4 4 bronze badges. To achieve this effect, you need to use Conditional Formatting:. Note: DATEDIF function will exclude the start date when counting the month numbers. CalendarDaysInLastMonth. =DATEDIF ( วันเริ่มต้น, วันสิ้นสุด, รูปแบบของผลลัพธ์. To calculate and display the time between two dates in days, months, and years, you can use the a formula based on the DATEDIF function. Number of days. The DATEDIF function returns the number of years, months or days between two dates and is officially "unsupported". Dim Msg. Select cell D2, which is the first blank cell in the Duration column. Days function gives you the number of days between. Here's how it does this: First the DATE function creates the date, 5/1/2016. Then type a formula like one of the following. In Excel 2013, I need to create formula to calculate years, months and days between two dates, if one or both dates is pre-1900. 3. Datedif not working in Excel 2013 Hi everybody, I tried to find if my problem was already discussed about, but I couldn't find what I'm looking for [please, if it is, paste. Excel knows it’s a date and simply calculates the number of days between those two dates. here is my sample. How to Use DATEDIF Function in Excel: 2 Ideal Examples. The Datedif function is used to calculate interval between two dates in days, months or years. Hoặc có thể đặt 3 phép tính trong 1 ô. Check Difference option from the Type section;; In the Arguments input textboxes, select the cells which. DATE function. When you test the Power Query function with the Excel function, you will see different results for the parameter MD. Example: You can not enter 11/12/2015 directly into the cell. A pure date is stored as a date as of crossing midnight (time of 0). I need to do the datedif function for every value from e2 to e151 and the amount of months from those dates to September 1 2013 with the values in j2 to j151 Solved by O. Excel 2013で[パスワードを使用して暗号化」したファイルのパスワード解除方法です。 暗号化したファイルを開き[名前を付けて保存]を実行します。 下の[ツール]をクリックします。 表示されるメニューの[全般オプション]をクリックします。 Hi Andrew I'm AnnaThomas and I'd happily help you with your question. Merci bien . XLOOKUP function (microsoft. OP needs to write the complete syntax of DATEDIF to make this workable. . #excel #absolute #viralvi. 07-21-2013, 12:28 PM #2. Antalet kompletta år mellan två datum. The DATEDIF function is categorized as a DATE/TIME function in Excel. A difference in complete months, Ignoring days and years. e. ) and some manually calculated results. Example 3. 1. Forum Guru Join Date 12-31-2011 Location Pittsburgh MS-Off Ver 2002, 2007:2013 Posts 18,890 This formula subtracts the first day of the ending month (5/1/2016) from the original end date in cell E17 (5/6/2016). DATEVALUE function. This Excel tutorial explains how to use the Excel DATEDIFF function with syntax and examples. "MD" trả về số ngày còn lại trong tháng. Click a cell where you want to locate the result, and then click Kutools > Formula Helper > Date & Time helper, see screenshot:. Write down the formula as: “=DATEDIF (A2,B2,"y")”. For example, to find the current age, in years, for the birth date in cell B2, enter this formula in cell C2: =DATEDIF (B2,TODAY (),”y”)datedif excel 2010 I can not find "datedif" under excel 2010 . Excel DATEDIF - calculating date difference in days, weeks, months or Check Details How to. In your selected cell, type the following formula and press Enter. ) Use the DATEDIF function when you want to calculate the difference between two dates. Tải và cài đặt Office 2013 Sử dụng bản thấp hơn, các bạn có thể tải và cài đặt Office 2007. YEARFRAC calculates a decimal number representing the fraction of a year between two dates. in 13 mins. Step 3: Implement the datedif in Excel. I use Excel 2013 and scandinavian dates and cannot get DATEDIF-function to work. DATEDIF: Excel 2003: Get days, months, or years between two dates : start_date end_date unit: DATEVALUE: Excel 2003: Convert a date in text format to a valid date. 0. Syntaxe: Syntaxe pro DATEDIF funkce v aplikaci Excel je:Solution: You have to change to the correct value. Syntax =DAYS (end_date, start_date). El resultado se muestra en la celda donde escribes la ecuación en tu hoja de cálculos y es exhibido en un formato entero al lado de las fechas que quieres evaluar. =DATEDIF(A2,B2,"m") Number of years between two dates. 2. Use the DateDiff function in VBA code. Calculate an integer amount of months between Start and End dates. The start_date and end_date arguments are required while the unit argument is optional. It creates it using the year in cell E17, and the month in cell E17. Funkcija DATEDIF. Calculate Difference Between Two Dates Using DATEDIF Function. Second, let me point you to the newly released LET function, which will enable you to write in a formula only once something like DATEDIF (A3, (B3- ( (B3-A3)-NETWORKDAYS. Fungsi DATEDIF, Rumus Excel untuk Menghitung Umur Rumus Excel [. 按照函数日期与时间类别搜索→没有 2. Excel can help you calculate the age of a person in different ways. La diferencia puede ser en días, años o meses. . Datedif #num help. The function name almost gives away its purpose. Example 1: Calculate Tenure in Years and Months. . . #2. Some of these may cover older versions, so there can be differences in the user interface shown. DATEDIF - Hàm đếm số ngày, tháng, năm trong Excel 2007 2010 2013 2003. This space at the. This step by step tutorial will help all levels of Excel users calculate the number of years between two dates. จะคำนวนหาอายุใน Excel ใช้ฟังชั่นอะไรอะครับ ?? Microsoft Excel Microsoft Office. The syntax of the DATEDIF function is DATEDIF (start_date,end_date,unit). For example, the formula =DAYS360("1-Jan-2021","31-Dec-2021") returns 360 days. I'd like to know why I get two different results when calculating date differences on the same dates:Calculate the difference between two dates in Excel. Each video comes with its own practice worksheet. 3 Determine Number of Years. By. Using the DatedIf function I am. DATEDIF takes 3 arguments: start date, end_date, and "unit", which controls which result is returned. Problems can occur if dates are entered. This is why in Excel 2016 it is not promoted. Calculate the difference between two dates. Then the first of the current year is subtracted from the first of the next year. Syntaxe : DATEDIF ( Date1; Date2;Intervalle) Date 1 est la date de Départ. Top Contributors in Excel: HansV MVP. Follow the steps to calculate the age using YEARFRAC():. Then the 1 represents the first day of that month. Then, we have used DATEDIF again pretty much the same way to return the number of months but the code has been. Namun percayalah jika kalian teliti dan berhasil menguasai penggunaan yang tepat seperti pada formula datedif ini maka semua pekerjaan menjadi mudah. Do đó bạn hãy nhớ công thức hàm và các tham số của nó như tôi sắp giới thiệu sau đây: Cú pháp: =DATEDIF (start_date, end_date, Interval) Trong đó: start_date: Ngày bắt đầu tính. First one is "2016-02-14" and the second one is "2016-03-10". Penggunaan Rumus DATEDIF ini tida sulit, Karna kamu hanya memerlukan beberapa langkah saja untuk menyelesaikannya. Salah satu fungsi rumus DATEDIF Excel 2007 dan 2016 adalah menghitung selisih tahun, lalu biasa digunakan untuk menghitung umur atau masa kerja karyawan. Foto: Nada Shofura/kumparan. The DATEDIF function is available in any version of Excel, but it is not shown in the list of functions. Whenever I type a function into Microsoft Excel 2013, a small hint box is displayed which lists the function's arguments. Rumus DATEDIF yang digunakan untuk menghitung selisih hari adalah =DATEDIF (start_date;end_date;"d"). Dates. By te way, DATEDIF is not needed for this kind of calculation. Solution: You have to change to the correct value. Vous ne trouverez pas cette. It is a hidden worksheet function and you will not find it in the list of functions but you can use it. Output: 11;. Fill in "d" for the third argument to get the number of days between two dates. Dates should be entered by using the DATE function, or derived from the results of other formulas or functions. Highlight cells C1 to C4, if necessary. =DATEDIF(A2, B2, "m") //difference in months. This function is a legacy function retained in Excel for. 2013 at 13:53. Bentuk umum formula DATEDIF adalah sebagai berikut. In the first instance, the output from this part of the formula will be 1Y. First put a start date in a cell, and an end date in another. INclude start and end date. Steps: Select the E5 cell first. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900. The value is in days (24 hours) not in seconds. 4 Calculate Number of Days Ignoring Years. The issue is that the end result is producing a negative number of days (-9 in this example) or months in cell E11. I can't find it listed anywhere on the formula tab, nor am I shown any reminder of what arguments to use. DATEDIF in Google Sheets: Formula & Examples - Add TODAY Function. Harassment is any behavior intended to disturb or upset a person or group of people. The DATEDIF (Date + Dif) function is a "compatibility" function that comes from Lotus 1-2-3. 3. 2. . Dates are stored as numbers, so whatever the outcome of your formula is, it will get displayed as the date that is as many days after 1 January 1900. To find the number of years between two dates. Funkcija DATEDIF može da izračuna pogrešne rezultate u određenim scenarijima. . This function does not appear in the 'Insert Function' dialog box and is not recognised in the 'Function Arguments' dialog box. Answer. . אזהרה: Excel מספק את הפונקציה DATEDIF כדי לתמוך בחוברות עבודה ישנות יותר מ- Lotus 1-2-3. - PHD in Economy ; - Certifyed Public Accountant ;- Auditor ;- 2 Years Master Deg. It's because the logic to calculate this parameter isn't the same for Excel. For example, the formula =DAYS360("1-Jan-2021","31-Dec-2021") returns 360 days. . =DATEDIF (Ausgangsdatum;Enddatum; "ym") Differenz in Tagen ohne vollständige Jahre. Excel Datedif = 13 Years (Expected Result) BigQuery Date_diff = 14 Years Does Anyone can help a query on BigQuery such. DATEDIF ensures that you're working with dates rather than date/times. Example 1: Common Uses. Need to know the number of years, months, or days between two dates? Excel's DATEDIF. 全部函数搜索，D开头的函数 试着直接输入DATEDIF搜索结果也找不到，是这个函数从Excel2016中消失了吗，可以. Summary. =DATEDIF(A2, A5, "y") - returns the number of complete years between the dates in A2 and B2. We will use it to calculate the. DATEDIF value: =DATEDIF (D3,TODAY (),"Y")&". S response is good enough, you can also multiply what you are getting by 86400 (which is the result of 60*60*24, you just save some. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. EDATE (start_date, months) The EDATE function syntax has the following arguments: Start_date Required. if C1 is blank and time interval between two dates (G2 and today) is more or equals F2-2, then ''Attention". Pertama, adalah menggunakan rumus DATEDIF yang berguna untuk membedakan dua hari dari berbagai variasi hari, bulan, dan tahun. The Excel DATEDIF function returns the difference between two date values in years, months, or days. 1. 指定した日から指定した日までの経過年数や日数などを自動計算してくれる関数 です。. The NETWORKDAYS function calculates the number of workdays between two dates considering both weekends and holidays. No lookup list required. The value is in days (24 hours) not in seconds. Combine All Three Formulas to Get the Actual Age. Meski demikian, bukan berarti formula ini tidak tersedia atau tidak bisa digunakan. شرح دالة حساب الفرق بين تاريخين في الإكسل، وهي دالة DATEDIF التي توفر الكثير من الجهد والعناء وتعطي نتائج مميزة. When we use "m" in the unit argument, Excel computes the. La fonction DATEDIF permet de calculer la différence entre deux dates. Hàm DATEDIF có thể tính toán các kết quả không đúng trong một số kịch bản nhất định. เปิดไฟล์ Excel หรือ เตรียมข้อมูล.