Explanation
The DAY function returns the day value for a date.
Alternative with EOMONTH
The EOMONTH function returns thelast dayof in the month of a given date.
The result is the first day of the “current” month (i.e.
first day of the month given by the date in A1).
you could use the DAY function to extract a day number from a date into a cell.
Use a positive value for months to move forward in time, and a negative number…
