Forum Discussion

LMiller1873's avatar
LMiller1873
Copper Contributor
Aug 05, 2022

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 (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

excel
Formulas and Functions
  • dscheikey's avatar
    dscheikey
    Bronze Contributor
    Aug 06, 2022

    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.

Resources