- 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.
- 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).
