I'm trying to figure out a macro that will prompt the user to input a weekday name. However, the user might input the weekday name as 3 letters (Mon, Tue, etc.) and the macro needs to:
- Recognize this condition
- Convert the 3-letter weekday name to the full weekday name (Monday, Tuesday, etc.) before continuing with the rest of the macro
This seems best suited to a sub-macro that will check the input before passing the result back to the parent macro.
Is there a way to perform this arithmetic?