Example #3 - First day of current monthĪlthough EOMONTH returns the last day of the month, you can use EOMONTH to get the first day month of the current month like this: =EOMONTH(TODAY(),-1)+1 // first day of current month EOMONTH, with zero (0) for months, uses the current date to calculate the last day of the current month. The TODAY function returns the current date to the EOMONTH function. To get the last day of the current month, combine the TODAY function with EOMONTH like this: =EOMONTH(TODAY(),0) // last day of current month You can use EOMONTH to move through years as well: =EOMONTH(B5,12) // returns May 31, 2018 With in cell B5: =EOMONTH(B5,0) // returns May 31, 2017 The EDATE function returns the same day of the month n months in the past or future. Note: The EOMONTH function returns the last day of the month n months in the past or future. To display the result as a date, apply a number format of your choice. The months argument specifies how many months in the future or past to move – use a positive number to move forward in time, and a negative number to move back in time.ĮOMONTH returns a serial number corresponding to an Excel date.

The EOMONTH function takes two arguments: start_date and months. You can use EOMONTH to calculate expiration dates, due dates, and other dates that need to land on the last day of a month. The EOMONTH function returns the last day of the month a given number of months in the past or future.

Ms excel 2018