Copper Contributor

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 (starting in K2) and if not it will work down those rows until it find the return value needed


 unsure how to go about this

1 Reply

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.




You can also use the following formula:




 Hope that helps.