Using Excel's Date, Month, Day, and Right functions to extract a date value with varying formats
Hello, How do you extract dates from different columns if the month and day are in the same column and the year is in a separate column, using the Date, Month and Right function? The DATE function in Ms Excel has three arguments year, month, and day. The syntax for this function is as follows: =DATE(year, month, day) The month and day are in the same column in this video, but the year is in a separate column. You can use the MONTH function to extract the month from cell C2 (which contains a date in the format "Mar-02"). The syntax for this function is as follows: =MONTH(serial_number) To apply this function to cell C2, you can use the following formula: =MONTH(C2) Next, you can use the DATE function to combine the year from cell J2 and the month and day from cell C2 into a single date value. The formula for this is as follows: =DATE(J2,MONTH(C2),DAY(C2)) Note that the DAY function extracts the day from cell C2. Finally, you can use the RIGHT function to extract only the day ...
