Microsoft Excel - Working With Dates Part 1

Question 1: How do I retrieve the date of the first and last day of a date's month?

The following screen shot shows an Excel workbook containing a column (A) of dates from which we extract the first and last dates of the month of these dates:

Excel DAY Function

Return the First Day of  the Month

The First Day of the month for a given date can be returned using the DAY function in Excel:

=A2 - DAY(A2) + 1

Excel EOMONTH Function

Return the Last Day of  the Motnh

The Last day of the motnh for a given date can be returned using the EOMONTH function in Excel;

=EOMONTH(A2,0)

If you would like to learn more about Microsoft Excel functions tale a loom at our Microsoft Office Excel Training Courses.