To separate the day from a date in Microsoft Excel 2019

  1. Click on a cell in the worksheet to return the day from a datevalue. For this example, select cell H2. Enter =day( into thecell. Click on the date cell you are retrieving the day from. Selectcell B8.
  2. Press Enter on the keyboard to display the day as theresult. Experiment with the year and month functions on the worksheetusing =month(G6) and =year(G6).

Leave a Comment