I am trying to create a personal budget sheet with three columns for inputting data either weekly monthly or annually. How can I make it that if I enter date in one cell, say monthly; that it automatically calculates the weekly amount and the annual amount and vice-versa if entered into weekly or annual cells?

Any help would be greatly appreciated as I am going nuts trying to work it out