Forum Discussion
Stumped
How would you go about automating the begin month cell so that if the corresponding cell in Column H is equal to the date in row 1 (starting at K1) it will return the number value of the month cell (...
Hi LMiller1873,
I don't understand exactly what you want to achieve, but with the EOMONTH() function you can also determine the first day of a month. In my example, from the date in cell H20.
=EOMONTH(H20,-1)+1
You can also use the following formula:
=DATE(YEAR(H20),MONTH(H20),1)
Hope that helps.