Convert date to month and year in Excel and Google Sheets

=TEXT(A2*29,"yyyymm")

A2 = date cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert date to month and year in Excel

How to convert date to month and year in Excel?
Convert date to month and year in Excel

CONVERT DATE TO MONTH AND YEAR — EXCEL FORMULA AND EXAMPLE

=TEXT(A2*29,"yyyymm")

=TEXT(A3*29,"yyyy-mm")

💡 Detailed month and year format explained here

Convert date to month and year in Google Sheets

How to convert date to month and year in Google Sheets?
Convert date to month and year in Google Sheets

 CONVERT DATE TO MONTH AND YEAR — GOOGLE SHEETS FORMULA AND EXAMPLE

=TEXT(A2*29,"yyyymm")

=TEXT(A3*29,"yyyy-mm")

💡 Detailed month and year format explained here