Converting the Moon Name and Moon Number

An Excel file that teaches how to perform Converting the Moon Name and Moon Number operation.

Excel Format: Converting the Moon Name and Moon Number

In the study, month names were converted into corresponding month numbers. It is aimed to interpret the month information entered as text in a consistent manner. Simple control structures have been added to prevent incorrect month names. Flexible formulas have been used to adapt to different writing styles. It is intended that the results can be used safely in other calculation tables.

Hope it is useful.