Question ID: 1540 13/19
PREVIOUS QUESTION NEXT QUESTION

In the cell range B2:D21, insert the appropriate functions so that
column B displays the day of the date appearing in column A,
column C displays the month of the date appearing in column A,
column D to displays the year of the date appearing in column A.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


In the cell range B2:D21, insert the appropriate functions so that 
column B displays the day of the date appearing in column A,
column C displays the month of the date appearing in column A, 
column D to displays the year of the date appearing in column A.