Can someone please assist me in writing a For/If statement that will look at each cell in every other row in range K10:AV48, and format it based on the following conditions:
If the date in each cell is the current year, format it as m/d, but if the date is next year or beyond, format the number as m/yy.
Any assistance would be appreciated. Thanks!
If the date in each cell is the current year, format it as m/d, but if the date is next year or beyond, format the number as m/yy.
Any assistance would be appreciated. Thanks!