Given today’s date e.g. 2016-10-04 I need to get the values of the first and last day of the previous month 2016-09-01 and 2016-09-30, I can get the last day by:
=EOMONTH(K1,0)
But do not know how to get the first day. Basically the opposite of the EOMONTH function.