A few hours are sometimes enough to start generators when renewable energy supply decreases. Obviously, the more capacity the better, but costs will increase linearly with capacity in most cases.
Pumped-storage hydroelectricity - where it is feasible - is the only kind of energy storage close to "months".