Forum Discussion
Solved
Want to show specified text based on month in selected cell in excel
Hello everyone, I'm stuck with the next problem: I am creating something like resource list of parts in maintenance. My goal is to show text in a cell based on year quartals (jan, feb and mar ar...
For this setup
that could be
=EDATE( EOMONTH( DATE( 2000+RIGHT(C3,2), LEFT(C3)*3, 1), 0), LEFT(B3, SEARCH(" ", B3)-1)*12)
For this setup
that could be
=EDATE( EOMONTH( DATE( 2000+RIGHT(C3,2), LEFT(C3)*3, 1), 0), LEFT(B3, SEARCH(" ", B3)-1)*12)