Get the correct dates according to selected quarter and year,

[danpan]

So here goes, I have been playing around with a workbook (trying to automate it as much as possible. But I seem to be struggling with this part here.
I have a basic table where the date, salary amount and the pay period go in. Now in the date boxes as the pay date is always the last working day of the month I was trying to get it to fill it in automatically according to the year, quarter if that makes sense .Any help would be appreciated!

 

[C Moore]

This would go in Date cell
=EOMONTH(RIGHT(payperiodcell,LEN(payperiodcell)-SEARCH("-",payperiodcell))*1,0)

 

[danpan]

This would go in Date cell
=EOMONTH(RIGHT(payperiodcell,LEN(payperiodcell)-SEARCH("-",payperiodcell))*1,0)

Thank you thats worked, would you be able to explain the formula so I can understand how it works? t
Again thank you for your help!

 

[C Moore]

Excel will recognize the text FEB2023 as a date (2/1/2023) if entered that way in the cell. RIGHT pulls the number of characters we want from the right end of the text, LEN/SEARCH tells it how many characters to pull based on where the dash is. This returns text. By multiplying by 1 we are telling EXCEL its not meant to be text. EOMONTH takes the now found 2/1/2023 and gives the last date of the month. If you use evaluate from the formulas tab and evaluate each step it will show you what's happening.