Can I have a specific word (in a cell) generate a formula to another cell?

So I want to make due dates for visits but unsure if the way I am thinking about is even possible.    I would want the words "weekly," "bimonthly," "Monthly," and "quarterly," to generate the formu...