Feb 23 2022 07:55 PM
My question is in the workbook. But I want to return the month 2021 based on a drop down. For example if B2 says January, I want cell B6 to return January 2021.
Thanks in advance.
Feb 23 2022 10:02 PM
Feb 23 2022 10:05 PM
@catherine9910 You could just enter =B2&" 2021" in B6, I guess.