If Column A contains month name, multiply a range by a specific number

Hi experts! I'm wondering if this can be done in VBA.

Column A contains the months of a year. Could be in the format of words like "January, February, etc" or in date form like "31/01/23, 28/02/23, etc".

Is it possible to use an If Loop to:
If Cell in Column A contains "January" or "31/01/23", multiply columns B:G in THAT ROW by 1
If Cell in Column A contains "February" or "28/02/23", multiply B:G in THAT ROW by 2
If Cell in Column A contains "March" or "31/03/23", multiply B:G in THAT ROW by 3
Etc all the way to December where u multiply B:G in that row by 12

a(i, c) = a(i, c) * mult

This line produces 'Type mismatch' error.

I uploaded a file to illustrate my example.

January: Multiply by 12/1 = 12
February: Multiply 12/2 = 6
March: Multiply by 12/3 = 4
April: Multiply by 12/4 = 3
May: Multiply by 12/5 = 2.4

Pattern continues until december

Test.xlsx