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 from cell C2.
The syntax for this function is as follows:
=RIGHT(text,[num_chars])
To apply this function to cell C2 and extract the last two characters (which represent the day), you can use the following formula:
=RIGHT(C2,2)
Putting everything together, the final formula to extract the date value with the correct year from cell J2, the right month from cell C2, and the correct day from the last 2 characters of cell C2 is as follows:
=DATE(J2,MONTH(C2),RIGHT(C2,2))
Comments
Post a Comment